I think the underlying thing that is being missed is that the readFields query only runs one time when in production mode. So the fact that it takes 1.6 seconds for this to run doesn't matter at all since it only happens one time, the first time the app is loaded. So instead of focusing on why this query takes 1.6 seconds, the real issue is why it keeps re-executing for you when it doesn't for anyone else.
On 5/14/07, Bryan S <[EMAIL PROTECTED]> wrote:
At this point I believe the root of my problem is the query in the readFields function in ObjectDao.cfc That query is taking 0.015 seconds to run in MSSQL but in Oracle it is taking 1.641 seconds even with the performance enhancement I posted at the start of this thread. At this point it would really help me a lot if someone who is using Oracle could time how long that query is taking for them so I could get an idea of how much of this is a database tuning problem. If it's normal for Oracle to take that long it narrows down my things to look at for a solution. I would really appreciate it if someone could report their results. Thanks. Bryan All that has to be done is: 1) open reactor/data/oracle/ObjectDao.cfc 2) find the readFields function 3) just ABOVE the query <cfquery name="qFields" put this code <cfset session.beginTime = GetTickCount()> 4) just BELOW the query put this code <cfset session.endTime = GetTickCount()> <cfset session.totalTime = session.endTime - session.beginTime> <cfdump var="#session.totalTime#" label="session.totalTime"> <cfabort> 5) Update any field in any table and report the results. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
