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
[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
