> *The prgama PRAGMA journal_size_limit = **N , *does not seem to limit > the size of the WAL log file. Is there any precondition to be > satisfied before calling the pragma ?
I have same problem (on Windows). See this console session: SQLite version 3.7.9 2011-11-01 00:52:41 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table waltest (data text); sqlite> pragma journal_mode=wal; wal sqlite> pragma journal_size_limit; -1 sqlite> pragma journal_size_limit=0; 0 sqlite> pragma wal_checkpoint; 0|-1|-1 sqlite> begin; sqlite> insert into waltest(data) values ("qwertyuiopasdfghjklzxcvbnm1234567890"); sqlite> insert into waltest(data) values ("qwertyuiopasdfghjklzxcvbnm1234567890"); sqlite> insert into waltest(data) values ("qwertyuiopasdfghjklzxcvbnm1234567890"); sqlite> insert into waltest(data) values ("qwertyuiopasdfghjklzxcvbnm1234567890"); sqlite> commit; sqlite> pragma wal_checkpoint; 0|2|2 sqlite> pragma wal_checkpoint(restart); 0|2|2 sqlite> pragma wal_checkpoint(restart); 0|2|2 sqlite>.quit WAL log is deleted on database disconnect only. On big writes WAL log grows and grows... even I commiting datas, even I have no long transactions, even I have autocheckpointing , even I do checkpointing manually. Just close and reopen database clears WAL log file. Is this correct behavior? Thank you! -- Lukas Gebauer. http://synapse.ararat.cz/ - Ararat Synapse - TCP/IP Lib. http://geoget.ararat.cz/ - Geocaching solution _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users