Doug This is the best performance I've been able to achieve. I have Cold Fusion debugging turned off. Model Glue reload turned off. Scaffolding is turned off. And yes, Reactor is in production mode. I'm not familiar with trusted cache or full garbage collection. How do I change those settings. Bryan
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hughes Sent: Friday, May 04, 2007 4:02 PM To: [email protected] Subject: Re: [Reactor for CF] Oracle Performance Improvement Just wondering, did you ever test this in Production mode for reactor and reload off in model-glue? I assume performance was much better. Not to mention the fact that you'll want to disable rescaffolding in Model-Glue. Oh, and turn on trusted cache. And maybe disable explicit full garbage collection in jrun. I guess my point is, are you improving the performance of fully development mode or production mode? Doug On 5/4/07, Bryan S <[EMAIL PROTECTED]> wrote: I forgot to mention that I timed the query all by itself using: <cfset session.beginTime = GetTickCount()> RUN QUERY HERE <cfset session.endTime = GetTickCount()> <cfset session.totalTime = session.endTime - session.beginTime> <cfdump var="#session.totalTime#" label="session.totalTime"> and my change caused the query to go from nearly seven seconds to just over two seconds. Bryan -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ <http://www.mail-archive.com/reactor%40doughughes.net/> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Doug Hughes -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
