Hi Pavel,
On 7/9/2011 10:16 PM, Pavel Ivanov wrote:
1. If we have a 1MB cache (1000 pages x 1KB/page), is it allocated
immediately and used or is it allocated as queries come in?
Cache is not allocated immediately. It's allocated when SQLite needs
to read something from disk (or write a newly
> 1. If we have a 1MB cache (1000 pages x 1KB/page), is it allocated
> immediately and used or is it allocated as queries come in?
Cache is not allocated immediately. It's allocated when SQLite needs
to read something from disk (or write a newly created page). SQLite
reads it and caches.
> 2.
Hi All,
We are right now reviewing our usage of SQLite3 and are seeing how we
can optimize its usage of disk space, run-time memory and its
performance for our applications. So far, we are discovering a lot of
new things - and it's very interesting to see things we may have
overlooked at
3 matches
Mail list logo