Posted by: Charles Maitland | Thursday 2 February, 2006

Feel the power

I have just done a test on the main query for the data warehouse.
The query has 9 joins from 7 tables, 7 additional criteria in the where clause.
One of the tables has 7 million rows, another 15 million rows.
SQL Server 2005 crunched it in 16 Mins 15 Secs and returned 4.5 Million rows.
Not bad considering it was running on MY LAPTOP!
I cant wait to see it run on the server with Dual Xeons large RAM and Raid.
 
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: