Reputation: 75973
I'm wondering how SQLite implements it. Is it based on file-locking? Surely the entire DB isn't locked for every user that accesses it; that would be extremely inefficient. Is it based on multiple files or just one big file?
Would be nice if someone could give a short overview of how synchronization and locking is done in sqlite, or, of course, provide a link to one.
Upvotes: 3
Views: 2234
Reputation: 8040
Have a look at the SQL Lite FAQ and this on locking. Hope this helps.
Upvotes: 6