Daniel.Berger
Wed, 15 Nov 2006 07:30:23 -0800
Well, thanks first for all your answers.
I try to answer all these questions:
> Teddy
> I think what everyone is getting at is the fact that
> so many people do not have this issue that it sounds
> like it has a contributing factor in your environment.
Yes, I thought that too, but I could not find the problem.
> Contributing factors:
> Network latency of CF to DB round trip
> Configuration of Reactor.xml set to "development"
> Possible framework reloading
> CF Admin settings
> Server hardware or software issues of queued requests
We have several other sites running on these servers, with normal performance.
I use this code to invoke reactor:
<cfparam name="recreateReactor" default="false">
<cfif (NOT structKeyExists(application.at3, 'reactor')) OR (recreateReactor EQ
true)>
<cfset application.at3.reactor = CreateObject("Component",
"reactor.reactorFactory").init(expandPath("/at3/v1_0_0/config/reactor_" &
LCASE(ListFirst(CGI.SERVER_NAME,'.')) & ".xml"))>
</cfif>
> It is hard for us to troubleshoot when there is a just plethora of
> possible things that can make any code generation slow.
That is clear
> Doug
> Are you using a framework?
> Make sure any framework you are using is not set to reload on every request.
> for example, in model glue set reload=false in the configuration.
> this can make a 4 second difference.
No, I am not using a framework, well, I have to admit that we use a small self
grown mvc framework,
but as far as I can see, that does not influence reactor.
I will try to make some standalone tests with reactor to exclude that safely.
> Tom
> Turn CF debugging on so you can grab the select SQL statement
> and try it by hand, or via a normal cfquery.
> Is the problem still there using these other methods ?
We usually have CF debugging always on on our dev servers.
I replaced the .load methods with manually created queries - it is still much
to slow.
When I look at the output of the debugging it seems that most of the time is
spent in some reactor core classes.
> João
> I never had this kind of problem when loading a record object.
> You mean that you take 4.5 sec just to load 1 record?
Yes, exactly. out of a table with 5 fields and 5 data rows..
> I've been off for a while and didn't have check the latest
> versions of reactor but my performance issues are with iterators with far
> more records.
> What mode of reactor are you running? Development?
I tried every mode.
Ok guys, thank you for your help, i will try to benchmark a little standalone
reactor app.
Dani
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --