On Wed, Sep 22, 2010 at 12:02:33PM +0200, Michele Pradella scratched on the wall: > I have a question about "PRAGMA cache_size" > if I use the default value(2000) and I use the default value for the > page size, what is the max memory size sqlite can reach in a request?
The *cache* can grow to something on the order of (page_size + 100) * cache_size (there is some overhead), but the total memory consumption can be higher if transient tables or indexes are required to service the query. These allocations are typically short-lived, however. Normally each database connection has its own cache. If you need to hard-limit SQLite's total memory footprint, you use sqlite3_config() and several other functions to provide a static memory pool, or provide your own memory allocator. -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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
