On Sun, 2005-09-18 at 01:03 +0400, Alexander J. Kozlovsky wrote:
> Hence, SQLite deferred transactions is not serializable ones.
>
Your understanding is incorrect. SQLite does *not* release
locks in the middle of a transaction - ever. It is always
serializable.
--
D. Richard Hipp <[EMAIL
Yes, I understand now.
Thanks for explanation!
Best regards,
Alexander mailto:[EMAIL PROTECTED]
> SQLite transactions are always serializable.
Serializable mode requires two-phase locking protocol. In practice
it means all locks (for read and for write) hold until transaction
end.
Deferred transaction drop SHARED lock in middle of transaction
and replace it with
3 matches
Mail list logo