Hi Everyone, I'm quite new to Coldfusion, having only used it for the 6 months I've been in my current job, so there are many things that I just don't understand yet.
My current problem is performance. I have a Fusebox 3 app running on Coldfusion. There are quite a few db queries that use joins of 2 or 3 tables, but nothing that should confound the server too much. In fact the sys admin has checked his logs and tells me the querries aren't running slowly. Most of the time, the app runs smoothley. But every now and again, it just hangs for an extended period (30+ seconds). I only noticed this behaviour once I'd deployed the app to our production server. But then I started looking at the dev server and the same problem could be seen there, only on a smaller scale. When I run the Coldfusion Admins debugging tools (execution times) on the dev machine, I get occasional execution times of 400 to 1000 (or more) ms on the dev machine. For comparison, the app normaly runs in less than 100ms. The timeouts are 10 times (or more) longer on production. I assume this is due to the load on the production machine. I'm perfectly willing to accept that my own inexperience with CF has lead me to write some bad code. But I'm having trouble reliably reproducing the effect on the server. I can click through the same sequence of steps repeatedly, and have it run smoothy 9 times out of 10, then bang! Hangtime! The only common factor I can find is that it seems to happen about every 100 - 110 seconds (a little less than every 2 minutes). The session variables are set to time out in 20 minutes, so I don't think they are causing the problem. I need to go over my code with a fine tooth comb, but there's a part of me that suspects the server. Could this be some kind of caching issue? And how best can I debug this? Any advice greatly welcome, Lucien. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
