Re: [sqlite] Checkpoint time

2011-12-02 Thread Richard Hipp
On Fri, Dec 2, 2011 at 2:15 AM, Sreekumar TP wrote: > There is another reader but sharing the same connection. So checkpoint > process cannot be blocked by another reader. > The other reader doesn't have to be active - it merely needs to be holding open a read transaction. Perhaps you have fail

Re: [sqlite] Checkpoint time

2011-12-01 Thread Sreekumar TP
There is another reader but sharing the same connection. So checkpoint process cannot be blocked by another reader. On Thu, Dec 1, 2011 at 8:54 PM, Yves Goergen wrote: > On 01.12.2011 18:58 CE(S)T, Sreekumar TP wrote: > > During the measurement of manual checkpoint times, I see the following >

Re: [sqlite] Checkpoint time

2011-12-01 Thread Yves Goergen
On 01.12.2011 18:58 CE(S)T, Sreekumar TP wrote: > During the measurement of manual checkpoint times, I see the following > behaviour - > > # of WAL frames checkpointed is over 1000 > size of DB has not changed after checkpoint.(measured using fstat) > Time for the checkpoint if around 500 ms. > >

[sqlite] Checkpoint time

2011-12-01 Thread Sreekumar TP
Hello, During the measurement of manual checkpoint times, I see the following behaviour - # of WAL frames checkpointed is over 1000 size of DB has not changed after checkpoint.(measured using fstat) Time for the checkpoint if around 500 ms. Why is it that eventhough 1000+ frames are checkpointed