On Sat, Dec 27, 2008 at 12:38 PM, Jake Maul <jakem...@gmail.com> wrote:
> > 3) Obviously it'd probably be faster if you weren't using > SQL_NO_CACHE... guessing you just did that to show us what it's like > that way? > > Why would SQL_NO_CACHE slow it down? By not checking the cache or storing the resultset into cache it should be quicker, at least a little bit. Unless, of course, the query would always return the same result set. But with count(*) in there it might not. In fact, I believe the count(*) would prevent MySQL from caching the query in the first place, like using now() - it's a non-deterministic function. -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
