On Wed, Oct 1, 2008 at 4:53 PM, Milan Babuskov <milanb@...> wrote:

> Timothy Madden wrote:
>> This SELECT Count(*) problem is really incredible. I can understand
>> concurent
>> transactions see different versions of the same table. Why is it
>> difficult for every
>> of these versions to also have their own row count ?
>
> Because such count would have to be kept in system tables, and it would
> mean versioning system tables - which has proven to be tricky so far.

How about letting the system tables reflect the base version of the table and
put the per-transaction row-count toghether with the version-specific data of
the table ?

Thank you,
Timothy Madden