Re:SQLite improves performance with memory-mapped I/O
by emn13 on Friday May 24, 2013 @07:40AM
(#5762163)
I believe you can approximate table-level locks in sqlite by splitting your database into multiple files. Transactions across multiple databases are atomic (provided you don't use WAL), so you're still in a fairly safe place. However, I'm not sure how practical it is to split a database into lots of files; or whether the sqlite engine deals efficiently with queries that span many databases, for instance - I've never actually done this.
But if you really need a particular table to be writable without locking the rest of the database, it's probably a fairly decent workaround.
But if you really need a particular table to be writable without locking the rest of the database, it's probably a fairly decent workaround.