Archive of:
 CF-Talk
Cold Fusion - Technical
home
24 hour view
quick stats
weekly updates
all tallylists
corporate solutions
archive your favorite
help / feedback
About Cold Fusion :
product's home
product's list home
|
|
Archived TallyList / CF-Talk:
Subject: RE: SELECT * Queries
 Jonathan Lim (1p/+0r) Posted: Saturday 31 Mar 2001
This post: 40 views, +0 rating
Hi Bud,
My DBA told me that the * will mean more data has to be transferred from the DB server to your CF server. That's what slows it down. The DB time spent getting the data for * or for a specific field is negligable. We're working with DB2.
HTH Jon
> -----Original Message----- > From: Bud [mailto:webcreation@mindspring.com] > Sent: 31 March 2001 13:37 > To: CF-Talk > Subject: SELECT * Queries > > > Hi all. I've always been told, and read here that using * in SELECT > queries is slower than specifying the field names. I just happen to > be working on a site now where I have a page with 3 big SELECT > queries. One of them with over 100 fields. If I use * in lieu of the > field names, the page execution time is reduced from +- 250 > milliseconds to +- 185 milliseconds, with the actual query times > being cut by about 1/3. > > Anyone else experience this? The 2 largest queries have no joins, but > even the one with a join goes from 50 ms to 35 ms if I use: > SELECT L.*,B.* > > Have I been reading this wrong? I've sure wasted alot of time > entering field names into Select queries , not to mention slowing > down my apps. > > Thanks, > -- > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > buddy@twcreations.com > http://www.twcreations.com/ > 954.721.3452 > >
Similar Subject Line Posts (+/- two weeks of this post)
| Send a reply to the CF-Talk list! |
 |
NOTE: Many lists will reject your post unless you have already registered with them. Also - don't forget the right account to send from (for those with multiple emails!) |
|
