Re: [sqlite] SQLite memory calculator (was Multiple sessions, page sizes and cache)

2017-04-27 Thread Kim Gräsman
On Wed, Apr 26, 2017 at 11:00 PM, Kim Gräsman wrote: > > I've used a spreadsheet internally to forecast how much memory SQLite > will need in a given configuration. > > I've cleaned/generalised it a little and posted here: > https://docs.google.com/spreadsheets/d/1cCawZE9AdF4jlmgAMjbz_pGZI0o9WkWdd

Re: [sqlite] SQLite memory calculator (was Multiple sessions, page sizes and cache)

2017-04-27 Thread Kim Gräsman
Hi Simon, On Wed, Apr 26, 2017 at 11:46 PM, Simon Slavin wrote: > > On 26 Apr 2017, at 10:00pm, Kim Gräsman wrote: > >> Specifically, I wonder if 4MiB for the general-purpose heap is maybe >> entirely unreasonable? Is there a way to forecast how much memory will >> be necessary for transactions

Re: [sqlite] SQLite memory calculator (was Multiple sessions, page sizes and cache)

2017-04-26 Thread Simon Slavin
On 26 Apr 2017, at 10:00pm, Kim Gräsman wrote: > Specifically, I wonder if 4MiB for the general-purpose heap is maybe > entirely unreasonable? Is there a way to forecast how much memory will > be necessary for transactions and query processing, or does that > depend entirely on the workload? De

[sqlite] SQLite memory calculator (was Multiple sessions, page sizes and cache)

2017-04-26 Thread Kim Gräsman
On Fri, Apr 21, 2017 at 5:18 PM, Kim Gräsman wrote: > Hi all, > > On Sun, Jan 15, 2017 at 5:50 PM, Richard Hipp wrote: >> On 1/15/17, Kim Gräsman wrote: >>> >>> 1) If I configure a global SQLite heap with SQLITE_CONFIG_HEAP, won't >>> I just trade malloc heap fragmentation for SQLite private hea