Hello Simon, Thanks for looking into my issue.
>> If, during your testing, you're using existing database files, please >> create new ones each time. I am not sure if I understood this suggestion. After making my code changes, I creates a new database file in WAL mode and still observed the issue. I cannot create new database file when system is running as the data in database is non-volatile in nature >> Can you please publish your schemae ? Just paste them into an answer. I have six tables in database and below is the schema for each of these tables. CREATE TABLE DB_TYPE_1 (Point INTEGER PRIMARY KEY, val BLOB) CREATE TABLE LOG_TYPE_1 (seq_number INTEGER, timestamp INTEGER, val BLOB, flags INTEGER) CREATE TABLE LOG_TYPE_2 (seq_number INTEGER, timestamp INTEGER, val BLOB, flags INTEGER) CREATE TABLE LOG_TYPE_3 (seq_number INTEGER, timestamp INTEGER, val BLOB) CREATE TABLE LOG_TYPE_4 (seq_number INTEGER, timestamp INTEGER, val BLOB) CREATE TABLE LOG_TYPE_5 (seq_number INTEGER, timestamp INTEGER, val BLOB) I have created indexes on seq_number and timestamp column for LOG_TYPE_* tables. >> Are you defining transactions (with BEGIN) or letting SQLite do it for each >> INSERT ? Yes, I am using "BEGIN TRANSACTION" and "COMMIT TRANSACTION" in my code. I don’t know much about this as this piece of code is legacy >> Do you have any UPDATE or DELETE commands, or just INSERT ? For LOG_TYPE tables, I am using INSERT or RELACE command. I am using following command since database tables are of fixed size. Once entries reach maximum point, then application starts overwriting last records. "INSERT OR REPLACE INTO LOG_TYPE_1 (rowid, seq_number, timestamp, val) VALUES (?, ?, ?, ?)" For DB_TYPE_1 table also , I am using INSERT or RELACE command. " INSERT OR REPLACE INTO DB_TYPE_1 (point, val) values (?, ?)" Regards, Tanuj Sharma -----Original Message----- From: sqlite-users <[email protected]> On Behalf Of Simon Slavin Sent: 14 November 2018 10:11 To: SQLite mailing list <[email protected]> Subject: [EXTERNAL] Re: [sqlite] WAL file size increase On 14 Nov 2018, at 4:20am, Sharma, Tanuj [AUTOSOL/FMP/IN] <[email protected]> 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 each time. Can you please publish your schemae ? Just paste them into an answer. Are you defining transactions (with BEGIN) or letting SQLite do it for each INSERT ? Do you have any UPDATE or DELETE commands, or just INSERT ? Simon. _______________________________________________ sqlite-users mailing list [email protected] https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=jOURTkCZzT8tVB5xPEYIm3YJGoxoTaQsQPzPKJGaWbo&r=_gjw_zrI4ADZe7LuhFpe8zUXhlmZyMwy8JPAklVQDxc&m=SpLorZc8tHx50vw-G_xBiLaCT2T2AqURz2BEf1p3vk8&s=rXsfHNEgx8sCbeH4fOmHbxpz4Z-4UVNj5y4VROL9o3g&e= _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
