On 3 Nov 2012, at 12:26pm, Jaco Breitenbach <jjbreitenb...@gmail.com> wrote:
> My application consists of several indepent processes that must all access > (read) the same data table during processing. In order to optimise memory > usage I was wondering if it is possible to load an in-memory SQLite > database into shared memory. Not simply and not without a little strangeness. However, SQLite has a Shared Cache mode which is easy to use, and you can open your database on disk, but declare a really big cache size for it. This will remove the need to use an in-memory database since SQLite will gradually read the whole database in to the cache. Read this: <http://www.sqlite.org/sharedcache.html> and this: <http://www.sqlite.org/pragma.html#pragma_cache_size> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
