How many records are in the Products table? Is the PartNumber column
indexed? How many columns are in the Products table (because of the *)?
> 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
