Re: [sqlite] cache size and insert-only

On Fri, Oct 28, 2011 at 5:36 AM, Jay A. Kreibich wrote: > On Fri, Oct 28, 2011 at 01:33:31PM +0200, Gert Corthout scratched on the wall: >> we have a database that only performs insert statements on a table >> (database contains only this table), is it in this case a good idea >>

Re: [sqlite] cache size and insert-only

On Fri, Oct 28, 2011 at 07:36:24AM -0500, Jay A. Kreibich scratched on the wall: > On Fri, Oct 28, 2011 at 01:33:31PM +0200, Gert Corthout scratched on the wall: > > > > hello all, > > > > we have a database that only performs insert statements on a table > > (database contains only this

Re: [sqlite] cache size and insert-only

On Fri, Oct 28, 2011 at 01:33:31PM +0200, Gert Corthout scratched on the wall: > > hello all, > > we have a database that only performs insert statements on a table > (database contains only this table), is it in this case a good idea > to reduce the cache size to, say, 5? No, that would be

[sqlite] cache size and insert-only

hello all, we have a database that only performs insert statements on a table (database contains only this table), is it in this case a good idea to reduce the cache size to, say, 5? Because if I understand things correctly the cache doesn't really help you when you do nothing but inserts,