PDA

View Full Version : Long transactions


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 :-)