Copy link to clipboard
Copied
We recently migrated to a new server and installed ColdFusion 11 Standard upon it. We went with CF11 so that a higher number of concurrent requests could be made upon our database. To our dismay we are seeing no improvement migrating from CF 10 (on the old server) to the newer CF11 on the newly created server. In fact the latency and web site hangs seem to be even more prevalent despite the fact that only 4 users are typically accessing the site at any one time. Adobe tech support is researching possible solutions at this time. In the meantime, we would appreciate any tips that this forum users might lend to shed some light on what the underlying issue might be. Interestingly, when 3 requests or less are made (we have been monitoring this with FusionReactor) the pages work efficiently.
In fact we are considering SQL Express or MySQL at this time. Thank you!
Copy link to clipboard
Copied
What is FusionReactor telling you when the 4th request starts to hang?
Do you know what code CF is trying to execute when it hangs?
Have you checked the CF error logs to see if you are getting any errors before, during or after then hang?
What database are you using? Have you checked the query executions when the page is running to see if its the queries taking time due to lack of indexing etc?
Where did you see that CF11 gives higher concurrent requests to your database compared to CF10?
Copy link to clipboard
Copied
I suspect a slowed-down database connection, and also wish to know your database brand. It usually takes one request to hang a server, not four: the proverbial last straw that broke the camel's back.
Copy link to clipboard
Copied
The database is MS Access. The hang occurs on just about any query made after only a small number of concurrent requests. And yes, CF10 actually performed better. Many thanks to Adobe Tech Support, who continue to troubleshoot our dilemma.
Copy link to clipboard
Copied
After 4 requests, huh? Why not just move over to the Community Edition of MySQL? It is superior to MS Access, as database, and can handle thousands and thousands of requests, no sweat. Besides, it is free.
Copy link to clipboard
Copied
In fact we are considering SQL Express or MySQL at this time. Thank you!