Re: Coldfusion 8 erratic behavior
a db queries being fast or slow is irrelevant. What about closed connections, what about slow responses from the database server, what about network issues between web and database server. All of these can cause a page to run slow or even hang waiting for a reply from the server. If a user closes his browser or goes away form the page before a response is received, then this can also leave the original request hanging. On Sat, May 25, 2013 at 7:49 PM, Richard Steele r...@photoeye.com wrote: Thanks. But no, the db queries are fast. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 8 erratic behavior
How can I determine what causes a coldfusion 8 page to be fast loading sometimes and other times, extremely slow? The server seems to have enough memory and the traffic is not high. The db query part of the page is fast according to Fusion Reactor. I don't see any leads in the Fusion Reactor Request Detail. What else should I check? Thanks in advance. Rick One thing to check, that no one else has mentioned specifically here, is what else is running concurrently with that page when it's slow. A stack trace may show you an indication that this page is waiting for something else to finish. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355846 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 8 erratic behavior
Check coldfusion's server monitor - in the statistics page, look for cumulative server usage..I had a similiar problem and it turned out to be a denial of service attack against 1 page.. and it did not show up on google analytics. Look for a huge amount of traffic. At 01:20 PM 5/26/2013, you wrote: How can I determine what causes a coldfusion 8 page to be fast loading sometimes and other times, extremely slow? The server seems to have enough memory and the traffic is not high. The db query part of the page is fast according to Fusion Reactor. I don't see any leads in the Fusion Reactor Request Detail. What else should I check? Thanks in advance. Rick One thing to check, that no one else has mentioned specifically here, is what else is running concurrently with that page when it's slow. A stack trace may show you an indication that this page is waiting for something else to finish. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355847 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 8 erratic behavior
Like Russ said, check the stack. If you can't seem to catch it, you can set up FusionReactor to send you notifications (that include the stack trace) when threads hit a certain time in their life span. You said you didn't think it was DB. How did you determine that? Does it mean you are using the FusionReactor JDBC wrapper on the datasource? If not, then I suggest doing that so you can get a full picture of what's going on with the DB actions in your request. On 5/24/13 8:39 PM, Richard Steele r...@photoeye.com wrote: How can I determine what causes a coldfusion 8 page to be fast loading sometimes and other times, extremely slow? The server seems to have enough memory and the traffic is not high. The db query part of the page is fast according to Fusion Reactor. I don't see any leads in the Fusion Reactor Request Detail. What else should I check? Thanks in advance. Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355839 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 8 erratic behavior
Thanks. But no, the db queries are fast. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355843 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion 8 erratic behavior
How can I determine what causes a coldfusion 8 page to be fast loading sometimes and other times, extremely slow? The server seems to have enough memory and the traffic is not high. The db query part of the page is fast according to Fusion Reactor. I don't see any leads in the Fusion Reactor Request Detail. What else should I check? Thanks in advance. Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355836 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 8 erratic behavior
when it is being slow, do a stack trace and it should give you an idea what is causing it. usually it is a db query. On Sat, May 25, 2013 at 1:39 AM, Richard Steele r...@photoeye.com wrote: How can I determine what causes a coldfusion 8 page to be fast loading sometimes and other times, extremely slow? The server seems to have enough memory and the traffic is not high. The db query part of the page is fast according to Fusion Reactor. I don't see any leads in the Fusion Reactor Request Detail. What else should I check? Thanks in advance. Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355837 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm