>- see footer for list info -< Ah! I'll have to change a few settings in my head and try again...
On the face of it getting data from the CF server's memory must be quicker than going across the network. Adrian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Terry Riley Sent: 29 October 2008 12:38 To: [email protected] Subject: RE: [CF-Dev] cachedwithin or mysql query cache >- see footer for list info -< That was a MySQL *cached* query, not a straight query..... Does your inhead benchmark still agree? Cheers Terry ----- Original Message ----- > *From:* "Adrian Lynch" <[EMAIL PROTECTED]> > *To:* "Coldfusion Development" <[email protected]> > *Date:* Wed, 29 Oct 2008 10:31:04 -0000 > > >- see footer for list info -< > I thin the difference in servers would have to be huge before the DB > started > to beat the cached query. > > But of course that's after I benchmarked it in my head just now! > > Adrian > Building a database of ColdFusion errors at http://cferror.org/ > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Terry Riley > Sent: 29 October 2008 10:24 > To: [email protected] > Subject: [CF-Dev] cachedwithin or mysql query cache > > > >- see footer for list info -< > I've looked to see if anyone has done any benchmarking to compare the > page request times using a query cached on the CF server using > cachedwithin (and cfqueryparams, now that CF8 allows it) and not > caching > on the CF server, but pulling from the MySQL server query cache, with > the MySQL being on a separate server. Can't find anything, so I > thought > I'd ask here for advice and/or links. > > If they give similar times for creating the page, then it would > probably > come down to which server's memory to use. > > Any offers? > > Cheers > Terry > http://www.confexdb.co.uk/ _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
