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

Bud (237p/+2r) Posted: Saturday 31 Mar 2001
This post: 67 views, +0 rating

On 3/31/01, Jonathan Lim penned: >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.

I understand that if I only needed data for 10 out of 100 fields, then yes it would be quicker to name the fields. But what about when I need the entire record? I read from someone on here that CF had to do an extra call to the database or something. Like once to get the field names and then to query it.

In answer to Luke, I'm using Access on this little app I'm building. --

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 (this post)	(67 v/ +0 r)
RE: SELECT * Queries	31 Mar 2001	(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!)