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

Thank you very much. You're super quick guys :) Cheers, Tomasz M From: sqlite-users on behalf of Dan Kennedy Sent: Thursday, March 16, 2017 8:34:30 PM To:

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 bandwidth. There is a problem that that fsync operations invoked from one thread are blocking other fsync operations

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

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 bandwidth. There is a problem that that fsync operations invoked from one thread are blocking other fsync operations invoked from another thread. I think that

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

2017-03-16 9:51 GMT+01:00 Dan Kennedy : > On 03/16/2017 01:40 PM, Tomasz Maj wrote: > >> Hi, >> >> >> According to my observations, "PRAGMA synchronous=...;" query affects >> only the standard sqlite pager. But for zipped databases sqlite uses >> additional ZIPVFS pager

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

On 03/16/2017 01:40 PM, Tomasz Maj wrote: 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

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

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