What does cfstat say for queued and running requests? Avg Queue Time
would be important too. Requests waiting in line to be processed would
cause exactly what you are seeing.
If this is on a Windows server, CF5 (earlier?) has a link that says
Performance that will show you the cfstat info in Perfmon (MX doesn't
have the link iirc, you have to enable perfmon in the admin. cfstat
works either way though), one of the things I like to do is start a
perfmon log and graph performance over a few days. It's one way to
quickly tell you when and why performance problems are occurring.
If you are on a shared server you can use this bit of code to see the
same info cfstat does.
<cfset stPerf = GetMetricData("PERF_MONITOR")>
<cfloop collection="#stPerf#" item="counter">
<cfoutput>#counter#: #stPerf[counter]#</cfoutput><br>
</cfloop>
--
jon
mailto:[EMAIL PROTECTED]
Wednesday, February 5, 2003, 3:08:22 PM, you wrote:
RAB> I've got an ECommerce site and every page but the home page loads
RAB> reasonably fast however the home page takes an average of 24 seconds to
RAB> process - when I debug and add up the process time of all the queries that
RAB> are running, they only total 160 milliseconds... which makes no sense to
RAB> me...
RAB> With debug on each query that's run shows the time like this:
RAB> GetHomeProduct (Records=6, Time=10ms)
RAB> Does this mean it tookk 10 milliseconds to run that query and get all six
RAB> records, or 10 milliseconds for every record?
RAB> How else can I determine the cause of the slowdown?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
