We experienced a similar problem with a report on a very large db; CF would make the request to the db server which would respond in about 30 to 90 seconds, meanwhile CFMX CPU usage slowly increased while it waited for the db response; my assumption was that it was cycling through some sort of "Are we there yet?" loop.
The real problem for us was that since we were only running 5 simultaneous requests (CFIDE setting) an excited user could easily chew up each available request slot meaning subsequent requests by any cf app were queued until these long processes were complete. Our solution was to go down the multiple instances of CFMX path and split these long tasks off onto their own instance, hence ensuring those tasks wouldn't affect the other apps on the same server. We're still running load test but it looks like multiple instances are working much quicker than the single instance, also for some reason CPU usage under load seems lower but that may just be a misread. Relevant article is: http://www.macromedia.com/devnet/mx/coldfusion/articles/multi_instances.html Cheers. Scott -----Original Message----- From: Yorke Hinds [mailto:[EMAIL PROTECTED] Sent: Thursday, 8 April 2004 08:25 AM To: CFAussie Mailing List Subject: [cfaussie] MX Performance/Memory I have large query that processes about 10,000 records, it take a short while to process but only happens once a day. I have notices MX chews up the CPU to max at 100%, it also consumes memory from 60MB to about 360MB. Once the query has run, the CPU returns to normal but the memory usage remains over 300MB. Any ideas to improve performance --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 IMPORTANT NOTICE: This e-mail and any attachment to it are intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. Views expressed in this message are those of the individual sender, and are not necessarily the views of the RTA. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
