Slow Queries on CFMX7

Our CF development box is running CFMX7 on Windows 2000
server and accesses a MySQL DB. Just this past week ALL of the CFM
pages on this machine started loading painfully slow. It appears
the problem is the time CF is taking to complete ALL its queries to
the DB. We've rebooted all machines involved to no avail. Also, the
same queries that are now taking 2-3 seconds for CF are executing
with no delay on the DB server itself. Finally, we found that
deleting the datasources from CF Admin and then re-creating them
fixes the problem. This was a royal pain because there are several
dozen DSNs on this development box.



Major points here:

-- This is happening on all of our datasources, regardless
of how complicated the query or the number of records returned.

-- It does NOT affect cached queries. Only those it is
actually retrieving from the DB

-- The exact same queries run on the DB itself run just fine.
This points to the CF server slowing down when making the
connection

-- All datasources are set to maintain connections to the DB
in CF Admin



Anyone know what causes this behavior or, perhaps, a quicker
fix than what we found?Slow Queries on CFMX7
Hi ,

from your problem , i figured out that yours query pages are
running slowing , Do one thing add take out the page which is
taking time and which has query in it , add CFDUMP tag around it ,
and take the dump of it , Its result will show you where it is
taking time .



What i think is that ur CF server is taking time to make
connection with database , so while executing a page , take a TCP
dump between these servers.