The only thing that I could imagine that would cause this would be if there
are that many more results or if your indexes aren't set up properly. You
should try creating the query in access and then call it with cfstoredproc.
You should see a big jump in performance if you do that. If you need help
doing that, just show your query here and I'll help you out.
-Michael
========================================
Michael Imhoff :::: www.omnicypher.com :::: icq: 10495667
[EMAIL PROTECTED] (home) :::: (320) 255-4447 (home)
[EMAIL PROTECTED] (cell) :::: (612) 247-8159 (cell)
Allaire Alliance Consulting Partner
----- Original Message -----
From: Eron Cohen <[EMAIL PROTECTED]>
To: Cf-Talk <[EMAIL PROTECTED]>
Sent: Monday, May 22, 2000 5:53 PM
Subject: Query suddenly taking 7 times longer
> Hi Folks,
>
> "Suddenly" today a SQL query that was taking about 20 seconds to perform
> last week, is taking 140 seconds to return results. I have no idea what's
> gone wrong.
>
> I haven't changed anything on the forms and haven't touched the software
on
> the server in question recently. When a user executes a SQL search on a
> particular form, my CPU usage goes up to 100% and takes much longer to
> return the results of the query than it ever has before.
>
> I've rebooted my server & compacted and repaired my MS Access database,
but
> nothing seems to help.
>
> I am on Cold Fusion 4.51, IIS 4.0 and a Pentium 366 computer.
>
> Can anyone give me any ideas on where to look for a solution to this
> problem?
>
> Thanks,
>
> Eron
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
