Re: [sqlite] wal_autocheckpoint

2014-01-31 Thread veeresh kumar
, 2014 10:01 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] wal_autocheckpoint   On 02/01/2014 12:13 AM, veeresh kumar wrote: > Hi All, >   > Below is my Sqlite settings. The current database size is  ~ 8GB >   > PRAGMA journal_mode = WAL > PRAGMA synchronous

Re: [sqlite] wal_autocheckpoint

2014-01-31 Thread Dan Kennedy
On 02/01/2014 12:13 AM, veeresh kumar wrote: Hi All, Below is my Sqlite settings. The current database size is ~ 8GB PRAGMA journal_mode = WAL PRAGMA synchronous = NORMAL PRAGMA wal_autocheckpoint = 50" With the above check point, the time taken to commit transaction to actual

[sqlite] wal_autocheckpoint

2014-01-31 Thread veeresh kumar
Hi All,   Below is my Sqlite settings. The current database size is  ~ 8GB   PRAGMA journal_mode = WAL PRAGMA synchronous = NORMAL PRAGMA wal_autocheckpoint = 50"   With the above check point, the time taken to commit transaction to actual database file after reaching a checkpoint is 2.5 to 3