Re: [sqlite] Help with a Temp view issue

2013-10-23 Thread Vinay Boocha
updated in step4 On Wed, Oct 23, 2013 at 1:01 PM, Richard Hipp wrote: > On Wed, Oct 23, 2013 at 1:50 PM, Vinay Boocha wrote: > > > Dear Rich, > > > > Thanks for the response. I guessed it might need some cache but thought > it > > will refetch every time to e

Re: [sqlite] Help with a Temp view issue

2013-10-23 Thread Vinay Boocha
). Any way to notify the temp views to refetch the pages or always refetch pages before executing a query? My VFS is performing a multi-master replication without the knowledge of SQLite layer. On Wed, Oct 23, 2013 at 12:25 PM, Richard Hipp wrote: > On Wed, Oct 23, 2013 at 1:20 PM, Vinay Boo

[sqlite] Help with a Temp view issue

2013-10-23 Thread Vinay Boocha
Dear All, We are observing that temp views are using page cache even after setting the cache_size= 0. I am stuck debugging this issue for the last two days. Any pointers will be greatly appreciated. When we run a SQL query multiple times on a temp view our custom vfs is getting read call only for