Where is reactor inited? Is this a part of an MG unity app?
I can't do it today, but maybe we could use my connect account (over the weekend?) to do some debugging together. My suspicion is that there's something in your code that's causing this... but I'm not sure quite what yet. Why? Because the problem is outside of Reactor's expected behavior, I'm not seeing in (with sql server) and Beth doesn't see it (with oracle). If you're feeling frisky you could dig into the reactor factory and see why it's trying to run this query... EG, trace back up the tree till you find a line of code that appears to be the culprit. I wonder if maybe there isn't something related to file permissions on the server. Like, maybe fileExists throws an error or something due to permissions (sandboxing or file system permissions). This *might* result in this kind of situation, but it'd be weird to see a system where you're not allowed to read, but you can write. Doug- Hide quoted text - On 5/9/07, Bryan S <[EMAIL PROTECTED]> wrote:
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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- Doug Hughes -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
