Beth
Can you run this test for me so I can compare your results to mine. My
Oracle DBA is not available to me until next week and I am trying to
determine if perhaps this is a database tuning problem.
In reactor\data\oracle\ObjectDao.cfc
cffunction name="readFields"
PUT THIS JUST ABOVE THE QUERY
<cfset session.beginTime = GetTickCount()>
<cfquery name="qFields" datasource="#getDsn()#"
username="#getUsername()#" password="#getPassword()#">
AND PUT THIS JUST AFTER THE QUERY
</cfquery>
<cfset session.endTime = GetTickCount()>
<cfset session.totalTime = session.endTime - session.beginTime>
<cfdump var="#session.totalTime#" label="session.totalTime">
<cfabort>
YOU WILL HAVE TO REFRESH YOUR APP FOR THIS DEBUGGING CODE TO TAKE AFFECT.
RUN IT WITH THE OLD CODE AND IF YOU'D LIKE WITH MY NEW CODE AND SEE HOW LONG
IT TAKES ON YOUR SYSTEM.
For me it was nearly seven seconds with the old code and just over two
seconds with the new code.
Obviously if just this supporting query takes over two seconds my update is
going to be slow.
Thanks.
Bryan
On 5/5/07, Beth Bowden <[EMAIL PROTECTED]> wrote:
I wonder if we'd see a similar improvement in the other databases.
Given I work in development mode, I'm all for anything that would
speed things up.
On 5/4/07, Bryan S <[EMAIL PROTECTED]> wrote:
>
>
> 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
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
