Re: Timestamp Ordering granularity
From: Wojtek Narczynski <wojtek_at_power.com.pl>
Date: Fri, 24 Dec 2004 09:37:42 +0000 (UTC)
Message-ID: <cqgo16$2gi$1_at_nemesis.news.tpi.pl>
Date: Fri, 24 Dec 2004 09:37:42 +0000 (UTC)
Message-ID: <cqgo16$2gi$1_at_nemesis.news.tpi.pl>
Jonathan Leffler wrote:
> If you use TO and assign a single timestamp to a page, then the
> system will treat it as though any transaction that modifies any
> record on the page actually modified every record on the page.
> That's a conservative but safe way of dealing with it.
I understand that, but this limits concurrency. What I would like is to go on page level when contention is low, and fallback to record level when contention gets high.
Regards,
Wojtek
Received on Fri Dec 24 2004 - 10:37:42 CET