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:
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
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
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
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
5 matches
Mail list logo