On Wed, Oct 11, 2006 at 13:30:22 +0200, Fourat Zouari <fourat@xxxxxxxxx> wrote: > what's the benefits using a serialized trans ? All of the queries in the transaction see a consistant view of the database. So that two identical select queries will return the same information within a serialized transaction. (As long as the current transaction doesn't make any changes between the two selects that would affect their output.)