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

W Luke (95p/+0r) Posted: Saturday 31 Mar 2001
This post: 40 views, +0 rating

What Database are you using? I've found nearly no performance problems using * in lieu of specific fields in Access; in many cases it's been quicker by a large margin, not to mention coding it...

Perhaps the issue here is when/if the site expands, and is ported to Oracle or Sybase where performance would be a major issue?

Will -- will@lukrative.com -=- www.lukrative.com Local-Advertising -=- www.localbounty.com

----- Original Message ----- From: "Bud" <webcreation@mindspring.com> Newsgroups: dotcom.lists.cftalk Sent: Saturday, March 31, 2001 1:37 PM 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	(51 v/ +0 r)
RE: SELECT * Queries	31 Mar 2001	(40 v/ +0 r)
Re: SELECT * Queries	31 Mar 2001 (this post)	(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!)