Skip Menu |

This queue is for tickets about the DBD-SQLite CPAN distribution.

Report information
The Basics
Id: 58332
Status: resolved
Priority: 0/
Queue: DBD-SQLite

People
Owner: Nobody in particular
Requestors: tom [...] eborcom.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: 1.29
Fixed in: (no value)



Subject: Documentation error for preventing fsync
DBD::SQLite's documentation suggests using the following: PRAGMA default_synchronous = OFF However, when I run my application with this I still notice it blocking on disk. SQLite's documentation does not mention this setting: http://www.sqlite.org/pragma.html#syntax However, it does mention "synchronous". My application stops blocking on disk when I call: PRAGMA synchronous = OFF Maybe SQLite had different syntax in the past: I suggest updating DBD::SQLite's documention to use SQLite's currently documented syntax. Thanks, Tom
Hi. The pragma is reported to have been removed since 3.0. Fixed in the trunk. Thanks for the report. On 2010-6-11 Fri 08:41:52, TOMHUKINS wrote: Show quoted text
> DBD::SQLite's documentation suggests using the following: > PRAGMA default_synchronous = OFF > > However, when I run my application with this I still notice it
blocking Show quoted text
> on disk. > > SQLite's documentation does not mention this setting: > http://www.sqlite.org/pragma.html#syntax > > However, it does mention "synchronous". My application stops blocking > on disk when I call: > PRAGMA synchronous = OFF > > Maybe SQLite had different syntax in the past: I suggest updating > DBD::SQLite's documention to use SQLite's currently documented syntax. > > Thanks, > Tom
Fixed in DBD::SQLite 1.30_04. Thanks.