I would turn on debugging to get the output of the execution time for the
queries (showing at the bottom of your template).
Then I would run those same queries on the database server it's self
(through whatever interface... ie. if you are using Oracle - run through SQL
Plus).
Then compare the execution times.
I had to do this on a project once to show that the queries were taking the
same amount of time and that it wasn't the network causing the slow down.
Steven Semrau
SRA International, Inc.
Senior Member, Professional Staff
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Com: (703) 805-1095
DSN: (703) 655-1095
-----Original Message-----
From: Tracy Bost [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 20, 2001 2:00 PM
To: CF-Talk
Subject: Long Processing time of queries
If the coldfusion server is all of a sudden taking a really,really, long
time to process pages(ie. the database driven pages, & queries specifically)
and the people on the db server have ya convinced its not them, where would
you look next?
NT 4 sp 6a
CF 4.5 sp 2
The CF server shows no sign of memory strain or anything else. Only the
database connections are extremely long.
So far I have re installed the latest odbc driver. Haven't found anything
else to do yet.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
