>- 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 -< > > > > -- > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.549 / Virus Database: 270.8.4/1753 - Release Date: > 28/10/2008 21:20 > > Terry http://www.confexdb.co.uk/ -- No virus found in this outgoing message. Checked by AVG. Version: 7.5.549 / Virus Database: 270.8.4/1753 - Release Date: 28/10/2008 21:20 _______________________________________________ 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 -<
