Long transactions [Archive]

xanana_gusmao

10-10-02, 23:19

Hi,

In database related literature; I've come across the
term "long transactions". What does this exactly mean ?
From what I've learnt; transactions should be kept short
to facilitate concurrency.

Cheers,

Xanana

eperich

10-13-02, 18:06

Don't know about the term exactly but if you use a long transaction never set the transactino isolation level to serlizeabel.
Transactions will get executed in a serial way and thats bad :-)