Hi All, Below is my Sqlite settings. The current database size is ~ 8GB PRAGMA journal_mode = WAL PRAGMA synchronous = NORMAL PRAGMA wal_autocheckpoint = 500000" With the above check point, the time taken to commit transaction to actual database file after reaching a checkpoint is 2.5 to 3 minutes for a 8 GB database.Is it taking acceptable time taken as per sqlite standards? My concern is during this 2.5 – 3 minutes, Will application be able to perform any “new write operation” Or does the application has to wait for 2-3 minutes until merging of the data from WAL file to actual database operation gets completed ? Our application messaging is such that if the service does not respond to a message from client by 10 sec , it would give time out message. Is lowering the value of wal_autocheckpoint is the only way to handle this or is there any other way?
Thank you -Veeresh _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
