Bryan, I was digging around in an attempt to reply to your post on the MG list and i think i may have come up with the cause of you're problem, i'll try and explain what i found, so bare with me... I generated a scaffold for a table using the modelglueapplicationtemplate, and commented out the redirect result for the scaffold so i could inspect the readField count after the end of the commit. With reactor in development mode i saw 18 readFields calls, with it in production i saw 3. I thought that by setting MG reload to false this would drop to zero, but it didn't, it was still making 3 calls. So i added a <cfthrow> to ObjectDAO.cfc just before the qFields query and had a look down the stack trace. It seems that readFields is being called by ModelGlue.unity.orm.ReactorAdapter 57 <cfset var dict = getReactor().createDictionary(arguments.table) /> I haven't had looked into this thoroughly as its getting quite late now, but it seems that whilst most create methods will call readFields in production mode and cache the results, creating a dictionary will always result in a call to readFields. I've tested this outside MG and you still get calls to readFields even when a valid dictionary.xml has been created, reactor is in production mode and stored in a persistent scope. I hope that gets you closer to figuring this out, as i'm quite confused now :) cheers, chris ________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bryan S Sent: 14 May 2007 20:34 To: [email protected] Subject: Re: [Reactor for CF] Oracle Performance Improvement Brian That was my understanding. Thanks. Bryan On 5/14/07, Brian Kotek <[EMAIL PROTECTED]> wrote: Also, the ReadFields query isn't impacted by how many records are in your tables. It just reads the metadata from the system tables about the tables themselves (column names, types, etc.). -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
