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
