We are trying to migrate from CF7 to CF9. We are receiving many timeout errors (500 internal server error. The request has exceeded the allowable time limit Tag: CFQUERY). We do not receive these errors on the CF7 server. They both point to the same database.
The Oracle Views that are timing out are quite long. So we saw this as an opportunity to tune those queries. They are tuned and we saved about 70% of the time it takes to run them. Still, they time out on the CF9 server and not the CF7 server. We changed the SETTINGS -> TIMEOUT REQUESTS AFTER to 190 seconds to match our Production server (where it does NOT time out). Still it is timing out. Oddly, the timeout times are longer than the 190 seconds. However, there would be much political grief if I just upped the timeout limit, especially since it works fine on the CF7 server. CF7 time it takes to load page - 293 seconds and does not time out CF9 time it takes to load page - 221 seconds and times out Both these are with the much more efficent queries/views. ---- So why does it time out on CF9 and not CF7 or rather, what do I need to do to correct this and make it work like CF7? Secondly, why does it run past the 190 seconds anyway? I'm more just curious on this one, but maybe it will help me understand to I can determine a cure. ----- The only other setting that I see that might apply is: REQUEST TUNING -> Timeout Requests waiting in queue after N seconds. This N is currently set to the default of 60 where it says it should be the same as the Timeout Request setting. I can have them change this but I need to know that it is the correct change to make. Do you think that this is the problem? If not, or even if so, do you have any other recommendations, especially server recommendations? I'm pretty much at a loss at this point. We don't have direct access to the servers and when we ask for changes to the system, that takes a few days to enact them, so I need to be pretty sure that I am asking them to do something that will make an impact - without a lot of back and forth of (try this, oh, and try this, oh...) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:357081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
