Basically think of it this way, the data passed back from the database is
going to contain one record row for each one returned, which will either
contain 4 fields or 50 fields...if you return 100 rows that would be:
4 * 100 = 400
50 * 100 = 5000
I think it is clear which would be faster and more efficient...to add to it,
lets say that those fields are each 50 char fields....you can do the math
and figure out the amount of extra unneeded data that you are passing over
the pipe...
and lastly the pipe is usually one of your keys to performance
issues...always optimize what is going over the pipe to be the smallest
possible data set....
Hope that helps...
John
-----Original Message-----
From: Michel Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 12, 2000 11:33 AM
To: [EMAIL PROTECTED]
Subject: To wildcard or not to wildcard (the SELECT statement)
When we query with a star (*) in the SELECT statement,
does MS-Access return all the fields, even if they are empty?
I have over 50 fields in a perticuar table, but some pages only
use 3 or 4 of them. The rest are empty.
For performances sake, am I better off using:
<CFQUERY DATASOURCE="CSM" NAME="Data">
SELECT a1,a2,a3
FROM test
</cfquery>
instead of:
<CFQUERY DATASOURCE="CSM" NAME="Data">
SELECT *
FROM test
</cfquery>
Will it make a difference in speed?
(It would be alot simpler to use the *
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
