The warning about wildcards (*) is due to users wanting specific fields
yet returning a whole record b/c it's easier to type (which is a huge
waste). If you truely do want every piece of information (and will continue
to do so in the future ie. even if fields are added) then by all means
that's what a wildcard is for. One thing to consider with large queries is
the overhead of transmitting the statement itself, if you're getting a small
record set with many fields (or a single record) your sql statement can be
almost as large as the returned set. This is where stored procedures come
in, Access doesn't support them but you can store the query server side and
use it's views to mimic very basic sps. I never use Access if I have any
choice in the matter, so for the exact syntax to do so you might want to
check SWYNK out (http://www.swynk.com) whenver you have to do anything even
remotely related to M$ it's a great place to start, so is MSDN
(http://msdn.microsoft.com). Even with small queries executed thousands of
times daily the transmission of the query can account for a large part of
traffice. Without going into a lot of detail, other DBMSs (I use the term
loosely in regards to Access ;) with varying degrees of sp support will also
optimise/compile the query for added performance benefit.
-----Original Message-----
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: March 31, 2001 07:07
To: CF-Talk
Subject: RE: SELECT * Queries
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
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
