>>When you use *, the database has to do a lookup to figure out what the
actual column names are in the table, then do the actual select
statement. If you explicitly tell it what column names (even if you
want all of them), you eliminate that overhead.
I don't agree with this argument:
1) any decent driver will check the list of columns you supply any way,
to make sure
all columns exist.
2) with * the driver can get columns in their natural order in the
database, and this may
imply less manipulation while reading data. If you supply the list
of all columns, the driver
will probabily try to return the columns in the same order in the
dataset.
--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246112
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
