Rick Glos Life in Portland, Oregon.

New PC

28. September 2006 12:51 by Rick Glos in

I've been long overdue for a new PC.  I think the last one I built was in Jan of 2003 and if you're a gamer, you're usually getting a new rig every 2 1/2 years, not counting graphics card upgrades, etc. along the way.  So last Friday I spec'd it out and ordered up all the parts from newegg.  And when I got home from work yesterday it was like Christmas.  3 boxes of goodies on my doorstep.

I didn't think the price was too bad.  The machine is pretty close to one of the best you can build atm.  Short of RAID or a small step in a better processor.  But the RAM, Video, HDD are the best.  For now anyway... wait 6 months.

We had dinner at a tappas restaurant so I didn't get started building until about 7:30pm but I had it all together and loading the OS by 10pm.  I'm already amazed at how fast the hard drive is.  WinXP SP2 was thrown down in about 15 minutes.

Looking forward to installing some games and seeing how they look.

Here's the specs on the PC (for future reference):

Product DescriptionTotal Price
DISCOUNT FOR COMBO #8823($25.00)
Item #: COM
COOLER MASTER Ammo 533 RC-533-SWN1 Black/Silver Aluminum+Plastic front bezel; SECC chassis ATX Mid Tower Computer Case - Retail$74.99
Item #: N82E16811119098
ViewSonic VA1912wb Black 19" 8ms Widescreen LCD Monitor - Retail$214.99
Item #: N82E16824116373
ASUS P5B Deluxe/WiFi-AP Socket T (LGA 775) Intel P965 Express ATX Intel Motherboard - Retail$209.99
Item #: N82E16813131028
Intel Core 2 Duo E6600 Conroe 2.4GHz LGA 775 Processor Model BX80557E6600 - Retail$319.99
Item #: N82E16819115003
COOLER MASTER SAF-S12-E1 120 x 120 x 25mm SuperFlo Cooling Fan - Retail$7.99
Item #: N82E16811999072
ASUS EAX1900XT/2DHTV/512 Radeon X1900XT 512MB GDDR3 PCI Express x16 Video Card - Retail$346.99
Item #: N82E16814121554
CORSAIR XMS2 2GB (2 x 1GB) 240-Pin DDR2 SDRAM DDR2 800 (PC2 6400) Dual Channel Kit Desktop Memory Model TWIN2X2048-6400 - Retail$299.00
Item #: N82E16820145590
NEC 16X DVD±R DVD Burner Black IDE/ATAPI Model ND-3550A - OEM$29.99
Item #: N82E16827152058
COOLER MASTER RS-550-ACLY-SLI ATX12V/ EPS12V 550W Power Supply - Retail$119.99
Item #: N82E16817171009
Western Digital Raptor WD1500ADFD 150GB 10,000 RPM Serial ATA150 Hard Drive - OEM$229.99
Item #: N82E16822136012


26. September 2006 14:40 by Rick Glos in
Weather - Portland vs Milwaukee

I can't help but gloat right now over the weather difference back home to here.  Now I may be crying in a couple months but hey... it's nice out right now!

It was dark on the start of the ride this morning, and I had to wear the headlamp for the first time this year, but the sun was beautiful as it rose up next to Mt. Hood.  I forgot the camera at home.  I'll try and remember to catch a shot going over the I-5 bridge on Friday morning.

Riding and buying Liquor

25. September 2006 21:39 by Rick Glos in

Rode home tonight.  First time in a few weeks.  Maybe like 6-7 I think.  Anyway.  Beautiful day.  84 - sunny.  Must've been alot of bugs out because I ate quite a few.  Noticed I was pretty slow climbing the hills too.  Pushing the low gears at low reps.

Normally I'm a beer or wine drinker.  Last week we had a stretch of cooler weather and a couple days of rain.  Well there's nothing like a Tuaca and Hot Apple Cider.  Mmmm.  Do you know in Oregon and Washington you cannot buy hard alcohol at the grocery store?  What a pain in the ass.  You can buy beer and wine but you have to go to a liqour store to buy the hard stuff.  And the liqour store is only open until 7pm.  Not only that but you can't buy beer or wine at the liqour store.  So you are forced to make two trips... saving gas and good for the environment my ass.

Which is faster? Loading XML from disk or from SQL Server?

25. September 2006 10:39 by Rick Glos in

I'm going to geek out on you for a minute. I may start doing this abit more from time to time. Anyway...

We had an interesting discussion at work. Which is faster? Loading an xml document from hard disk or loading it from SQL Server. I had assumed it would be faster to load from HDD but never one to assume - I decided to let science do the work.

So I built up a little console app. It simply displays the time after loading an xml file from either hard disk or sql server.

Bottom line? Based on my tests, loading from disk is 4x faster. Even if sql server has your query cached, so it doesn't have to pull the data from disk, it's still 4x faster to load from HDD. Why? Because of all the API's you have to pass that data through just to get the data across the wire. In fact, I gave sql server the benefit of the doubt, loading the xml file into a table with only 1 column and 1 row, running the query over and over so it was cached, and finally the data is sitting local to the same machine the app is on. If the data was buried in a large table on a remote sql server, I'm sure the local copy would be even faster.

Load from HDD console output:
Starting ... [9/25/2006 9:33:56 AM]Finished ... [9/25/2006 9:33:56 AM]Elapsed time: 00:00:00.0156253
5 attempts:
Load from SQL Server console output:
Starting ... [9/25/2006 9:34:40 AM]Finished ... [9/25/2006 9:34:40 AM]Elapsed time: 00:00:00.0937518
5 attempts:

C# code:

   1:using System;
   2:using System.Collections.Generic;
   3:using System.Text;
   4:using System.Xml;
   5:using System.Data.SqlClient;
   7:namespace LoadXml
   9:class Program
  10:    {
  11:static void Main(string[] args)
  12:        {
  13:            DateTime startTime = DateTime.Now;
  14:            Console.WriteLine("Starting ... [{0}]", startTime);
  16: //LoadFromDisk();
  18:            LoadFromSqlServer();
  20:            DateTime endTime = DateTime.Now;
  21:            Console.WriteLine("Finished ... [{0}]", endTime);
  22:            TimeSpan timeSpan = endTime - startTime;
  23:            Console.WriteLine("Elapsed time: {0}", timeSpan);
  24:        }
  26:private static void LoadFromSqlServer()
  27:        {
  28:            XmlDocument xmlDocument = new XmlDocument();
  30: using (SqlConnection sqlConnection = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=tempdb;Integrated Security=SSPI;"))
  31:            {
  32:                SqlCommand sqlCommand = new SqlCommand("select [xmldocument] from [dbo].[sqlxml]", sqlConnection);
  34:                sqlConnection.Open();
  36: // use a reader since it's the fastest way to read data from sql server
  37:                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
  39:                sqlDataReader.Read();
  41: // use column ordinal instead of column name for faster access
  42: string xmlString = sqlDataReader[0].ToString();
  44:                xmlDocument.LoadXml(xmlString);
  45:            }
  46:        }
  48:private static void LoadFromDisk()
  49:        {
  50:            XmlDocument xmlDocument = new XmlDocument();
  51:            xmlDocument.Load("Sample.xml");
  52:        }
  53:    }

XML file:

1 <?xml version="1.0" encoding="utf-8" ?> 2 <books> 3 <book> 4 <author>Carson</author> 5 <price format="dollar">31.95</price> 6 <pubdate>05/01/2001</pubdate> 7 </book> 8 <pubinfo> 9 <publisher>MSPress</publisher>10 <state>WA</state>11 </pubinfo>12 </books>

SQL Server Script to create the table and data:

1 /* Create the table in tempdb and load the xml into it */ 2 use [tempdb] 3 go 4 5 ifexists (select * from sys.objects where object_id = object_id(N'[dbo].[sqlxml]') and type in (N'u')) 6 drop table [dbo].[sqlxml] 7 go 8 9 create table [sqlxml]10 ( 11 [xmldocument] nvarchar(2000) not null12 ) 13 14 insert into15 [sqlxml]16 ( 17 [xmldocument]18 ) 19 values20 ( 21 '<?xml version="1.0" encoding="utf-8" ?>22 <books>23 <book>24 <author>Carson</author>25 <price format="dollar">31.95</price>26 <pubdate>05/01/2001</pubdate>27 </book>28 <pubinfo>29 <publisher>MSPress</publisher>30 <state>WA</state>31 </pubinfo>32 </books>'33 )

Friday Night Fish Fry at a Packers Bar

18. September 2006 22:12 by Rick Glos in

IMG_1117Based on some advice from the Green Bay girl last weekend, we tried out the local packer transplant hangout, the Corbett Fish House.  Around here they call fish fry's "Fish and Chips" (like we're in Great Britain or something).  Actually maybe that's what they call it in the New England.  Maybe Kevin can confirm that?

IMG_1121So we walk in and I start taking pictures because I can't stop laughing.  The owner is a Wisconsin transplant (I forget which city).  There's a large Green Bay Packer flag hanging from the ceiling and all sorts of Green Bay paraphernalia hanging all over the place.  Towards the back near the bar there's an office that looks like a shrine.  The only thing missing was packer shirts and jackets on all the patrons.  The staff had green and gold shirts on.  But that might also be related to the University of Oregon Ducks.  Which are followed with strange type of madness around here... (get a real team people).

IMG_1119So how about the food?  Good beer.  Widmer Brothers Hefeweizen (the beer that started Ray and my beer snobbery 10 years ago).  Real Midwest fish fry although with a Northwest spin - Gluten free and environmentally friendly (no overfished species).  Deep fried cheese curds (of course).  Heidi had the perch.  I took on the Walleye.  Pretty good although I will say I prefer the fish without the skin which these still had on 'em.  In fact it's pretty hard to run across fish fry's with the skin on back home. 

Siebert's Pub - Salem, WisconsinIt was no Seibert's but still pretty good for being 2200 miles away (btw, if you're reading this and still live in Wisco and have never done Seibert's you should... best I've ever had - if you don't like fish the stuffed shrimp are awesome.  Just ask Ryan er "Frank the Tank" - just watched that last night buddy!).

Chicago style pizza?

17. September 2006 03:24 by Rick Glos in

IMG_1115So Thursday after work I decided to hit up a joint on the way home called BJ's Pizza and Grill.  Heidi was going out with one of her girlfriends so I thought I'd see how this place was.  They billed themselves as Chicago style pizza.  They brew their own beer and they're also a chain.  All locations on the west coast though.  Got there before happy hour ended so $2 beer and 1/2 price personal pizza.  Chicago style... NOT.  A deep dish Chicago style pizza usually involves 1 large sausage patty that covers the entire top of the pizza.  One of the most famous is Gino's East.  Usually you can only eat one slice.  Hence the name and having 1 piece of "pie".  Now if you are going to bill yourself as Chicago Pizza don't you think you should do it right or don't do it?  Maybe it's the name.  Chicago 'style' or 'essense' of Chicago.  The beer was good but I won't be back for the pizza.  I'm also still looking for a place that has Italian Beefs...

Movie Review: The Island

13. September 2006 13:31 by Rick Glos in

The Island (2005) B-

I was going to give this one a C+ but I liked the story was kind of interesting.  Matrix-like.  Although one of the few times I figured it out before the plot gave it too me.  I thought the people were food.  But close enough.

Recharge the batteries

11. September 2006 21:11 by Rick Glos in

Took it easy and hung around the house this weekend. 

Did some gaming.  Finished F.E.A.R. (FPS)  Completed the first campaign (1/5) in HOMM (turned-based strategy).  Tried the demo of Company of Heroes (WW2 RTS) which comes out tomorrow (Tuesday 9/12). 

Opening weekend football on Sunday.  This was one of those times where you notice you live on the west coast now.  Football is on at 10 am.  With the pre-game there's no more waiting for game-time.  It's on from rise to rest.  Went out to a local pub, Macadam Grill, for bloody mary bar and brunch and watch all the games.  Another thing that's funny out here is that you'd expect to have a bunch of Seattle fans.  Not so.  Many people that live here are transplants.  Plus there's no real 'Pro' team.  So at the pub there were all sorts of different jersey's.  Browns.  Vikings.  Chiefs.  And of course a 4 girls with Packers shirts.  I talked to one of them at the bloody marry bar.  They were from Green Bay and moved here a few years back.  I told her I just moved from Milwaukee and she gave me some names of some local bars that are Packer hangouts that also have authentic fish fry's, including fresh water fish.  Of course I had to mention that I was a Bears fan.  And my heart was so saddened to have the Bears shutout the Packers in the season opener (/kidding of course).  I can just imagine the gloom around the Harley offices on Monday...

It was also really wierd to have football on before you even get off work! I know it was a Monday night double-header but to have a game on at 4PM? Hey, guess that's a reason to hit up happy hour!

One thing that is cool around this area is that even though you "aren't from around here" you never here that.  Everyone welcomes you.  Even though I spent the last 10 years living in Wisco I would still never be considered "from around here" back there.  I think it's alot like that in the central/eastern states.  It just seems less... entrenched here.  It's hard to describe.


Dave Matthews

7. September 2006 22:49 by Rick Glos in

Gorge Amphitheater

Check out that venue... the Gorge Amphitheater.  It's like what Alpine Valley would be if it was set at the edge of a cliff.  It took about 4-5 hours to get here.  The high desert in the middle of Washington State.  I cannot believe the terrain that mother nature has created on this side of the continent.  Just awesome...