O.K. I think we are on to something! There is hope I can make my application perform reasonably.
I put a counter in reactor\data\oracle\ObjectDao.cfc cffunction name="readFields" to see how many times it was running through the query. Here are the results: Retest with readFields Counter Seconds readFieldsCounter init 1.34 0 list 0.82 0 add new (time for form to come up) 4.32 2 save (time for list to come back) 11.94 8 edit (time for form to come up) 0.92 8 save (time for list to come back) 12.11 14 edit (again) 1.36 14 save (again) 12.25 20 So as you can see it this appears to account for my slow down since the query takes about 2 seconds to run and it is running through that query six times per save. Since based on what I've read here this shouldn't be happening can some one give me a clue what to look for that may be causing this? What would cause an object to be deleted so that it needed to be recreated besides not having reactor in production mode (I have it in production mode)? Just to summarize. 1) I am using the modelglueapplication template as the bare bones basic app with just one table scaffold to do this test. That eliminates that chance that I am doing something weird in my code that would cause this. 2) I ran this test on my local machine. 3) I have debugging turned off in my local CFAdministrator 4) These are my model glue settings cut and pasted from my Coldspring.xml <property name="reload"><value>false</value></property> <property name="rescaffold"><value>false</value></property> <property name="debug"><value>false</value></property> 5) This is my reactor setting cut and pasted from my Coldspring.xml <property name="mode"><value>production</value></property> On 5/8/07, Doug Hughes <[EMAIL PROTECTED]> wrote:
Or, for whatever reason, the reactor objects are being deleted and need to be recreated. If it's in production mode, then Reactor still wouldn't run this query even if it's being reloaded over and over. Doug On 5/8/07, Brian Kotek <[EMAIL PROTECTED]> wrote: > > I'm not going to say 100%, but I'm about 95% sure that if that query is > running on every request then your instance of Reactor is not in production > mode, or else the Reactor instance itself is being recreated on every > request. >
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
