On Sun, Mar 6, 2011 at 5:41 AM, Martijn van Oosterhout <klep...@svana.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

Reply via email to