On Wed, Sep 22, 2010 at 04:30:46PM +0200, Michele Pradella scratched on the wall: > ok thank you, usually how big is the default page_size?
1024 for everything except Windows. The Windows filesystem module attempts to match the page size to the minimum write block of the filesystem. For a typical NTFS volume, that's usually 4K. Remember that it is the system that first creates the database, not the system using the database, that sets the page size. Non-WAL databases can change their page size as part of the VACUUM process, however. -j > Il 22/09/2010 16.17, Jay A. Kreibich ha scritto: >> 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 >> >> > > > -- > Selea s.r.l. > > > Michele Pradella R&D > > > SELEA s.r.l. > > Via Aldo Moro 69 > Italy - 46019 Cicognara (MN) > Tel +39 0375 889091 > Fax +39 0375 889080 > *michele.prade...@selea.com* <mailto:michele.prade...@selea.com> > *http://www.selea.com* -- 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