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
Download (untitled) / with headers
text/plain 542b
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
Download (untitled) / with headers
text/plain 729b
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.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.