> Hi, > I just wanted to add that I changed the program a little bit to not > use > transactions and threads, and I still get the same problem (huge WAL > file). > All I do is endless loop of insert, and every X insert, I perform a > checkpoint on another sqlite connection (but in the same thread). > It only worked if I do the checkpoint on the same connection.
You cannot run a checkpoint from within a transaction. If you are in shared-cache mode, this means you cannot run a checkpoint while any connection to the same database has an open transaction. Does that explain anything? Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
