>- 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 -<
