> Thanks for this Simon, but unfortunately this is legacy code, which has to > be used for a while. I just did an update to check for column change (we > have a column to tell us the record has changed, so we do not need to check > every column), and the WAL file size growth has dropped significantly. So, > will keep working at it. > > I have found that after performing 5000 single transaction inserts, the WAL size grows to approx 90MB. After a checkpoint, it becomes 0 and the main DB's size goes up by less than 2MB. Is my observation correct? Ie am I expecting such a huge size difference between the WAL and main DB file formats?
Regards Keith _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
