On Mon, Sep 12, 2011 at 12:29:56PM +0800, ?????? scratched on the wall: > Hi there, > > I just have a question. If I am using JDBC driver to connect to sqlite using > in-memory mode, > is there any limit about the data size?
PRAGMA max_page_count should work on in-memory databases. http://sqlite.org/pragma.html#pragma_max_page_count If you've ATTACHed the in-memory database, you'll need to issue the command like this: PRAGMA <dbname>.max_page_count = <n> Also note that this limits the page count, meaning the total size is dependent on the page size. In-memory DBs live in the cache, which also has a small per-page overhead, so the total memory usage will be slightly more than (page_size * page_count). -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
