ok I think the default is 1024.
So for 2000 of cache size:
(100+1024)*2000=2,2MB
Il 22/09/2010 16.30, Michele Pradella ha scritto:
> 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
*[email protected]* <mailto:[email protected]>
*http://www.selea.com*
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
