A question. Is there a significant variance in the number of rows in your MSSQL database and the Oracle database?
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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- "Come to the edge, he said. They said: We are afraid. Come to the edge, he said. They came. He pushed them and they flew." Guillaume Apollinaire quotes -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
