> *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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
