On 7/25/01, Philip Arnold - ASP penned:
>Try to only search on Indexed fields
>Never use SELECT *
I usually get quicker queries when using SELECT * if I need to get
the values of all or most of the fields. Of course it's the other way
around of you've got 20 columns in your table and only need the
values from a few of them. I used to always add all the column names
but now I test it both ways and go with the quickest.
--
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
