Clemens Ladisch wrote:
Techno Magos wrote:
So, memory sqlite is not really usable with multiple threads (readers).
While one might expect that multiple readers of *memory *content could
scale even better than with file content.
Concurrent accesses to the same in-memory data structures must be
serialized. In shared-cache mode, the connections share the cache, while
on-disk connections each have their own cache.
Is there some special mode possible to achieve scaling up throughput with
multiple threads for memory sqlite content?
Put a DB file on a RAM disk. Or on a normal disk (with looser synchronous
and journal_mode settings), and rely on the OS file cache.
Or just use SQLightning, which has no scalability limits for readers.
-- Howard Chu
CTO, Symas Corp. http://www.symas.com
Director, Highland Sun http://highlandsun.com/hyc/
Chief Architect, OpenLDAP http://www.openldap.org/project/
sqlite-users mailing list