> I am looking for help on a way to query a table fast and
> efficiently. I am currently using a ODBC connection to SQL2000
> Server with a simple CFQUERY tag doing the query. For a table
> with 18K records, it takes 14 seconds.
>
> I know this is not doing something correct!! Any help designing
> new query statements or set up of CF or SQL2000 Servers would be helpful.
Without seeing your SQL, some comments;
Index the table to hell and back
Try to only search on Indexed fields
Never use SELECT *
Use the (nolock) acellerator (sp?)
Some queries are actually faster to do specific tables in one query, then do
the second, then use CF5's Query a Query to join them
HTH
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
