> Paul, I'm afraid "hurd" isn't quite English. You can chose betweenThanks, now I will never forget. Homonyms are hard, and indeed 'hurd'
> herd and heard, as in:
> We're off like a herd of turtles!
> A herd of turtles?
> Of course I've heard of turtles!
> Why would I care what a turtle heard? I have no secrets from
isn't even a valid word. Perhaps I suffer from Stallmanitis. For
clarity, I meant to write 'herd', not 'heard'.
> The third reason is that result caching works much better thanYour first two reasons were highly MySQL specific. This one is
> statement caching on most competitive benchmarks, even
> if they are next to useless in practice.
general. Does this imply that you don't agree with the observation on
the demand pattern of web apps & alike 3-tier stuff?
> The more modern practice is to use memcached so at least the staleYup, memcached is the band-aid we're trying to get rid of.
> data is on your local machine.
> It doesn't always get the right answer, of course, but then neitherWhy? Fundamental issues or shoddy implementations? I'd say Oracle's
> does result caching. Result caching is a disaster with MVCC and
solution is correct in view of your concerns, and the MS solution
could be correct, if done right.