On 7/6/2010 2:58 PM, Kristoffer Danielsson wrote: > What you are saying makes sense. Thanks for your advice! > > > > However, I do believe there are times when vacuuming would be beneficial. For > instance, if a database for software X is detected to have 90% unused space > for a couple of weeks, then why bloat the harddrive? >
If there is lots of free space on the drive, why work at giving it a little bit more? In any event, knowing the database and hard disk usage patterns will lead to much, much, much better criteria for vacuuming than any general rule of thumb. Optimizing plentiful resources is non-optimal. Gerry _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
