Re: [sqlite] WAL file growth concern

2010-10-23 Thread H. Phil Duby
On Sat, Oct 23, 2010 at 9:26 AM, Bob Smith wrote: > On Sat, Oct 23, 2010 at 5:56 AM, Richard Hipp wrote: > > > > Is that what you are seeing? > > > > Which filesystem are you using? > > > > > > Thanks Richard, this does seem to be what I am seeing. I am definitely > seeing more writes during th

[sqlite] WAL file growth concern

2010-10-23 Thread Bob Smith
On Sat, Oct 23, 2010 at 5:56 AM, Richard Hipp wrote: > > Is that what you are seeing? > > Which filesystem are you using? > > Thanks Richard, this does seem to be what I am seeing. I am definitely seeing  more writes during the subsequent cycles and an explanation that this is likely due to the w

Re: [sqlite] WAL file growth concern

2010-10-23 Thread Max Vlasov
On Sat, Oct 23, 2010 at 5:56 AM, Richard Hipp wrote: > > Is that what you are seeing? > > Which filesystem are you using? > > > > I think the misfeature even easier to reproduce than with the scenario Bob wrote. If your admin has a "repeated query" feature, you even don't need writing a single li