TallyList : mailing list management, archiving, and analysis

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

Arden Weiss (85p/+0r) Posted: Saturday 31 Mar 2001
This post: 52 views, +0 rating

Simple question from my older twin -- what do you do to get these timings -- haven't done it before (obviously).

^ / \__ ( @\___ / O / (_____/ /_____/ Whoof... 410-757-3487

-----Original Message----- From: Jonathan Lim [SMTP:jonathan.lim@netdecisions.co.uk] Sent: Saturday, March 31, 2001 9:38 AM To: CF-Talk Subject: RE: SELECT * Queries

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)

RE: SELECT * Queries	02 Apr 2001	(52 v/ +0 r)
RE: SELECT * Queries	31 Mar 2001	(162 v/ +0 r)
RE: SELECT * Queries	31 Mar 2001	(57 v/ +0 r)
RE: SELECT * Queries	31 Mar 2001	(66 v/ +0 r)
RE: SELECT * Queries	31 Mar 2001 (this post)	(52 v/ +0 r)
RE: SELECT * Queries	31 Mar 2001	(40 v/ +0 r)
Re: SELECT * Queries	31 Mar 2001	(40 v/ +0 r)
SELECT * Queries	31 Mar 2001	(61 v/ +0 r)

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!)