Maybe youve already done this, but if youre getting your execution times from the Coldfusion debugging settings, try turning off Report Execution Times and enable Timer Information" on both machines and use <cftimer> to test your execution times on the query. CF9s Execution Time output is much more verbose and processing intensive than CF7 and it can really slow things down. You may find that the difference disappears or is minimal once that setting is disabled.
How does the execution time of the optimized query on CF7 compare against the same query run directly against the database? HTH, Jon On Nov 15, 2013, at 11:05 AM, Andrew Scott <[email protected]> wrote: > > Using monitoring software like seeFusion or FusionReactor would be your > best bet here. > > Regards, > Andrew Scott > WebSite: http://www.andyscott.id.au/ > Google+: http://plus.google.com/113032480415921517411 > > > > On Sat, Nov 16, 2013 at 2:56 AM, daniel kessler <[email protected]> wrote: > >> >> 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:357084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
