As with many things in the DBMS world, the answer is, "Maybe. It depends."
The primary things that will affect your performance are the row size, the
datatypes involved, and the indexing you have in place. Secondary to that
will be hardware - things like the amount of memory and type of disk
storage. However, I doubt very much that you will see a performance
difference of 2x no matter what you try.
--
Eric
_____________________
"Once the game is over, the King and the pawn go back in the same box."
-- Italian proverb
"Johnny Le"
<[EMAIL PROTECTED] To: "SQL"
<[email protected]>
> cc:
Subject: speed?
04/22/2005 09:53
AM
Please respond to
sql
Hi,
Does the number of columns in a table effect the performance? For example,
I want to select 7 fields and 100 rows of a 7 column table with millions of
rows. Will that be faster than if I select 7 fields and 100 rows of an 82
column table with millions of rows? So 7 vs. 82 columns. All other
factors remain the same. I am using MS SQL Server 2000. I would think it
is faster. What do you think? If it is indeed faster, how much faster are
we talking about here? double or tripple the speed?
Johnny
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Protect Your PC from viruses, hackers, spam and more. Buy PC-cillin with Easy
Installation & Support
http://www.houseoffusion.com/banners/view.cfm?bannerid=61
Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2238
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
