Hi, I'm using freelist_count pragma to test whether my sqlite db needs vacuuming. I'm running intensive inserts and deletes to the DB very often. I run the freelist_count pragma periodically and I get different values every time - sometimes I get large number and sometimes I get 0 or 1. Does this makes sense? How can it be explained?
For example: Iteration 1: Page_count: 17234731 Freelist_count: 1 Iteration 2: Page_count: 17498568 Freelist_count: 40012 Please advise, Thanks, Orit [Creative Zone by MediaMind]<http://feeds.mediamind.com/CreativeZone> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
