Re: [sqlite] [EXTERNAL] Re: WAL file size increase

2018-11-26 Thread Sharma, Tanuj [AUTOSOL/FMP/IN]
Okay Richard. I will create a script to reproduce the error and will share it. Regards, Tanuj Sharma From: drhsql...@gmail.com on behalf of Richard Hipp Sent: Monday, November 26, 2018 8:48:21 PM To: SQLite mailing list Cc: Sharma, Tanuj [AUTOSOL/FMP/IN

Re: [sqlite] [EXTERNAL] Re: WAL file size increase

2018-11-26 Thread Sharma, Tanuj [AUTOSOL/FMP/IN]
e reason for auto_checkpoint not working in WAL mode. I will appreciate help on this. Thanks for your help in advance. Regards, Tanuj Sharma ________________ From: sqlite-users on behalf of Sharma, Tanuj [AUTOSOL/FMP/IN] Sent: Thursday, November 15, 2018 8:45 AM To: SQLite ma

Re: [sqlite] [EXTERNAL] Re: WAL file size increase

2018-11-14 Thread Sharma, Tanuj [AUTOSOL/FMP/IN]
AL] Re: [sqlite] WAL file size increase On 14 Nov 2018, at 4:20am, Sharma, Tanuj [AUTOSOL/FMP/IN] wrote: > I want to know why auto_checkpoint is not working when there is no Primary > Key in the table. If, during your testing, you're using existing database files, please create new ones

[sqlite] WAL file size increase

2018-11-13 Thread Sharma, Tanuj [AUTOSOL/FMP/IN]
Dear SQL Developers / Users, I am using Sqlite3 in our project. My database has journal_mode set to WAL and has one writer & multiple readers. During normal mode of operation, only writing process is accessing database and there is no active reader connection I have observed that when I don't ha