> Is this true, or is the memory usage pretty much similar? Until you reach limit set by 'pragma cache_size' memory usage would be the same for in-memory database and on-disk database. When the size of your database grows beyond 'pragma cache_size' in-memory database starts to consume more memory than on-disk one, because it has nowhere to push pages out of the cache.
Pavel On Tue, May 10, 2011 at 9:18 AM, Tito Ciuro <tci...@mac.com> wrote: > Hello, > > I have been using memory-based databases (opened via :memory:) and > performance is great. However, one of the things I assumed with memory-based > databases was that memory usage would be higher than the temporary or > persistent databases stored on disk. Is this true, or is the memory usage > pretty much similar? I've perform a few tests with fairly small data sets and > I don't see a difference. Any ideas? > > Thanks, > > -- Tito > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users