[sqlite] Is it possible to change "synchronous" flag of ZIPVFS pager?

2017-03-16 Thread Tomasz Maj
Hi, According to my observations, "PRAGMA synchronous=...;" query affects only the standard sqlite pager. But for zipped databases sqlite uses additional ZIPVFS pager layer which actually decide whether and when to sync content of files associated with a database. It looks like "PRAGMA

Re: [sqlite] Is it possible to change "synchronous" flag of ZIPVFS pager?

2017-03-17 Thread Tomasz Maj
sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Is it possible to change "synchronous" flag of ZIPVFS pager? On 03/16/2017 05:00 PM, Tomasz Maj wrote: > I have an application which work with many zipped databases in WAL journal > mode and the databases are stored on a media of low write band

Re: [sqlite] Is it possible to change "synchronous" flag of ZIPVFS pager?

2017-03-16 Thread Tomasz Maj
oun...@mailinglists.sqlite.org> on behalf of Tomek Maj <majek...@gmail.com> Sent: Thursday, March 16, 2017 10:50:37 AM To: SQLite mailing list Subject: Re: [sqlite] Is it possible to change "synchronous" flag of ZIPVFS pager? 2017-03-16 9:51 GMT+01:00 Dan Kennedy <danielk1...@gmail.com>: >