Hello, I have a questions about the correct use of transactions and WAL. I am writing an application that: 1. should very fast 2. should be very responsive 3. don't care if the last N minutes of data will be lost (but DB should never be corrupted)
What I tried to do: 1. open a transactions and close it every 3 minutes (So most of the tune all work is on memory, and thus is very fast) 2. disable wal auto checkpoint (So I wont have very slow queries due to a checkpoint) 3. run wal checkpoint in another thread (with another connection) - so it wont affect the responsiveness of the main thread. Results: 1. process memory is increasing with no upper limit 2. eventually I get an I/O error Questions: 1. what am I doing wrong. 2. what is the correct way to achieve the goals I mentioned before. Thanks, Jon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
