Is PartNumber indexed in the Products table?
Bob
-----Original Message-----
From: Tracy Bost [mailto:[EMAIL PROTECTED]]
Sent: March 29, 2001 5:06 PM
To: CF-Talk
Subject: Why the long processing time on queries ?
I know this isn't SQL list but can someone please tell me why it could be
taking ColdFusion Server soooooo long to
process these two queries ?? ... Other queries to the same database server
seem to be processing just fine. But these two queries together are taking
almost 20 seconds for the CF server to process them
getprodleft (Records=3, Time=8612ms)
SQL =
SELECT *
FROM Products
WHERE PartNumber IN (6956122 ,6820898,6802862)
getprodright (Records=3, Time=8793ms)
SQL =
SELECT *
FROM Products
WHERE PartNumber IN (6820088 ,6390009,6849111)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
