, 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
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
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
3 matches
Mail list logo