Hi Doug, Enabling trusted cache drops the execution time to the 100-150ms bracket, which is good.
Cheers Chris -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hughes Sent: 09 February 2006 21:48 To: [email protected] Subject: RE: Reactor For CF Performance All I can say right now is that it's alpha software :) Why not skip creating the array and just use getImageQuery()? Also, I expect that a trusted cache would help performance. Either way, there is going to be tradeoff. Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Blackwell Sent: Thursday, February 09, 2006 4:52 PM To: [email protected] Subject: RE: Reactor For CF Performance Hi Joe, Yeah, definitely in production mode. Same code takes 500-1000ms on my puny dev box with debugging turned off. The page is simply creating the record and array, there is no layout or anything else going on. Out of interest what sort of execution time would you expect? I've not yet ventured into MG or MachII, maybe soon. Chris -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joe Rinehart Sent: 09 February 2006 21:31 To: [email protected] Subject: Re: Reactor For CF Performance Hey Chris, Glad it helped, but yeah, that's still a big hit - are you running Reactor in production mode? That's <mode value="production" /> vs. <mode value="development" /> in Reactor.xml. Also, if you're using Model-Glue or Mach-II, be sure they're in "production" mode as well. -Joe On 2/9/06, Chris Blackwell <[EMAIL PROTECTED]> wrote: > Ah yes... ;) > > I'm so used to running with debugging on, but normally I don't have a > couple of hundred lines in debug trace. > > A much more acceptable 200-300ms, I guess that's still probably a 10 > fold increase over a cfquery, but that's a fair trade off considering. > Maybe I'll use it as an excuse for an upgrade ;) > > Cheers, Chris > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joe > Rinehart > Sent: 09 February 2006 21:07 > To: [email protected] > Subject: Re: Reactor For CF Performance > > Hey Chris, > > If you go into the ColdFusion administrator and turn off debugging and > report execution times, does it speed up significantly? > > -Joe > > On 2/9/06, Chris Blackwell <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I'm writing an image gallery app, and I have a simple many to many > > relationship for image to gallery. My app creates the gallery record > > then calls getImageArray(). In production mode, on a dual 3ghz xeon, > > which is not under any other load it takes 1500-1900ms to generate the > > page even when returning an empty array. Does this sound right? If > so, > > that's one hell of a performance hit over a neatly joined cfquery that > > would execute in a few milliseconds. > > > > Cheers, Chris > > > > > > > -- > Get Glued! > The Model-Glue ColdFusion Framework > http://www.model-glue.com > > > > > > -- Get Glued! The Model-Glue ColdFusion Framework http://www.model-glue.com

