On Thu, Dec 09, 2010 at 12:17:34PM +0200, Yoni Londner wrote: > > > The alternative is to create your own VFS that stores the WAL index in > > heap memory. > I guess I have to do it, but I think this should be available in sqlite, > since it is a common case to use sqlite from single process (but > multithreaded), and using WAL index in memory will improve system > performance.
Given that the WAL index is mmap'ed, you're unlikely to see improvement in performance by storing it in heap memory. Reads/writes will go at main memory speeds once mapped into your address space, and under memory pressure, it will be no slower than if the heap was pushed to the swapfile. Christian _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users