Re: counting rows

From: E. Lefty Kreouzis <lefty_at_goedel.home.rtfm.gr>
Date: Sun, 2 Apr 2006 08:07:48 +0000 (UTC)
Message-ID: <slrne2v1io.qol.lefty@goedel.home.rtfm.gr>

Just to make things clear I did the test on 3 databases using 2 long running transactions. The results were as follows:

Database	Isolation Level		Result
Oracle 10g	Read committed		No locking
PostgreSQL	Read committed		No Locking
PostgreSQL	Serializable		No Locking
SQL Server 2000	default (read commited?) Deadlock

The above was done using the default implementation of count(*) for each database. My claim is that using a trigger would result in locking for all cases just because the trigger would update the /same/ row.

Lefty Kreouzis Received on Sun Apr 02 2006 - 03:07:48 CDT