SQLite Forum

lock and low concurrency
Login
> in most common case,one transaction want to read/write table_1 and another transaction read or write table_2.

Why does this need to occur side-by-each and not one-after-each?

True "side-by-each" is usually prohibitively expensive to obtain and in almost all cases is merely an illusion.