ok thank you, usually how big is the default page_size?
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*
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
