Re: [sqlite] SQLite Cache Usage

2011-09-07 Thread Mohit Sindhwani
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

Re: [sqlite] SQLite Cache Usage

2011-09-07 Thread Pavel Ivanov
> 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.

[sqlite] SQLite Cache Usage

2011-09-07 Thread Mohit Sindhwani
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