where's the query?
Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]
-----Original Message-----
From: David Clay [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 24, 2001 1:50 PM
To: CF-Talk
Subject: SQL Query
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.
Thank you for your time.
Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506
303.770.8506
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
