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.
