>>Others say you should specify
individual columns unless you intend to use all the columns in the
query because it takes less time to get the part of the data you need
than to get all the data.

Personally I am among these others.
And do not rely on the time shown by the CF server for the query. This time is only the time it takes to get
the query executed by the driver, not the time it takes to extract each record when you loop
on the record set. If you're using only a few columns, you may be drowing thousands of
characters from the datasource for each record, when you are using only a few ten.

--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to