Rob wrote:
Larry S. <[email protected]> wrote:Doing a profile back-up, and noticed that the folder has become quite a bit larger than in the past. Looking into it, I see three large files that stand out. These are: -- places.sqlite -- webappsstore.sqlite -- netpredictions.sqlite (the largest by far, more than half the total)."Places" sounds familiar, but the other two don't, especially "netpredictions". Can anyone tell me what these are, and, in particular, why the last one is so darn large?The reason why some of the .sqlite files are so darn large is partly the silly pre-allocation that is done on them. This is a pain for roaming profile environments as well. What I did when we still used seamonkey in our company: - download sqlite3.exe and put in a directory in your path (e.g. %windir%) - in the logoff script call this program to perform some maintenance on the sqlite files: cd [your Mozilla profile directory] sqlite3 cookies.sqlite "delete from moz_cookies where name like '\_\_utm%' escape '\'; delete from moz_cookies where expiry < strftime('%s'); vacuum" sqlite3 places.sqlite vacuum sqlite3 addons.sqlite vacuum sqlite3 extensions.sqlite vacuum Maybe you can try this on those new files as well.
I am no SQL guru, but I did install the SQLite manager tool in SeaMonkey for occasional use. Using it on the netpredictions file I see there is a DB setting "Auto Vacuum" that is currently set to "None" and was wondering if changing that to "Full" might accomplish something similar without the need for a logoff script. Anyone with more experience that can address the case for or against this?
Dave _______________________________________________ support-seamonkey mailing list [email protected] https://lists.mozilla.org/listinfo/support-seamonkey
