Also, try specifying the columns you are looking for (even if you're looking
for all of them)
Hatton
-----Original Message-----
From: Victor Chou [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 5:13 PM
To: CF-Talk
Subject: Re: Why the long processing time on queries ?
How big is the database, and is the PartNumber indexed? Scanning a big table
might take a while...
----- Original Message -----
From: "Tracy Bost" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 10:05 AM
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
