Dave - what does your query look like currently?
Also, I've never used ODBC with SQL, but have you tried doing it with a
connection via code, rather than the ODBC mechanism? With ODBC, you have to
go through a layer of interpretation each way (If I understand the workings
correctly), and this may be adding time.
John
At 02:50 PM 7/24/01 -0600, you wrote:
>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
