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

Reply via email to