Doug
Thanks for the response.
The application I am using for the purpose of this test is a copy of Joe's
modelglueapplicationtemplate which is a Model Glue Unity App. I used it to
eliminate the chance of it being any of my code that is causing the problem.
There are only two things I added to his template app:
in the ModelGlue.xml
<scaffold object="USER_MAIN">
<results>
<result do="view.template" />
</results>
</scaffold>
and in the view.template I am dumping my readFieldsCounter
<cfif isDefined("session.readFieldsCounter")>
<h3>session.readFieldsCounter =
<cfoutput>#session.readFieldsCounter#</cfoutput></h3>
<cfelse>
<h3>session.readFieldsCounter = "Not Defined"</h3>
</cfif>
I will dig into the reactory factory after sending this message and see what
I can discover. If I'm not able to fix this by then I would certainly be
willing to come into work this weekend to get this solved. I don't have
access to our Oracle database from home. I'm not sure exactly what you have
in mind. I just hope our firewall doesn't hinder what you want to try.
On 5/9/07, Doug Hughes <[EMAIL PROTECTED]> wrote:
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
