On 12/09/2010 04:08 PM, Yoni Londner wrote: > Hi, > > I want to use the feature that enable WAL to use heap memory instead of > shared memory for WAL index. > Using locking_mode=exclusive is not good enough option, since I want to > access the DB from two threads, and with locking_mode=exclusive I get > "database is locked" error. > > How can I use in memory WAL index while using multiple DB connections?
Presumably each thread has its own db handle. You could enable shared-cache mode (although that gives you table-level locking, not the MVCC WAL provides). The alternative is to create your own VFS that stores the WAL index in heap memory. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users