columns will or won't be used.
Just signed up to CF-Talk again after a while away.... minutes later and I
have three emails from the list, see as high volume as it used to be I see
:OD
Ade
-----Original Message-----
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: 14 August 2004 02:09
To: CF-Talk
Subject: Re: weird but consistent behavior
> So OT, why is using Select * a bad practice? URLs anyone?
The general consensus is that it's unnecessarilly inefficient. Not
everyone agrees obviously.
...
I should probably clarify this some...
Some people will tell you that even if you're going to draw every
column in the query anyway, you should still list each individual
column in the query because the database server has to take some small
amount of time to assemble the list when you specify the wildcard ...
not everyone agrees with this. 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. Especially if you happen to have text or
clob columns, I can't really find fault with this myself, but in cases
where every column in the query is used, I see nothing wrong with
using the wildcard.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
