On Sun, Mar 6, 2011 at 5:41 AM, Martijn van Oosterhout <kleptog(at)svana(dot)org>wrote:
> If it's really really important there are ways you can use trigger
> tables and summary views to achieve the results you want. Except it's
> expensive and when people are told that all of the sudden the count(*)
> performance isn't so important any more. :)
>
That's often perfectly fine, with read-heavy, single-writer workloads.
I definitely wish there was a way to create indexes to track counters on
various types of queries, even if it eliminates write concurrency on
affected writes. Doing it by hand is a pain.
--
Glenn Maynard