393965 - on idle (once a day?) do a full vacuum to defragment places.sqlite

Status: RESOLVED DUPLICATE of bug 395020

(Firefox :: Bookmarks & History, defect)

Description

[(not reading, please use [e-mail] instead)]

on idle (once a day?) do a full vacuum to defragment places.sqlite

from the sqlite docs:

"Auto-vacuum does not defragment the database nor repack individual database pages the way that the VACUUM command does. In fact, because it moves pages around within the file, auto-vacuum can actually make fragmentation worse."

so we might want to do a full vacuum.

see related bug #390244 and bug #385834

Comment 1

[(not reading, please use [e-mail] instead)]

sigh, a dup of my own bug.

Comment 3

[Gervase Markham [:gerv]]

Bug 451915 - move Firefox/Places bugs to Firefox/Bookmarks and History. Remove all bugspam from this move by filtering for the string "places-to-b-and-h".

In Thunderbird 3.0b, you do that as follows:
Tools | Message Filters
Make sure the correct account is selected. Click "New"
Conditions: Body   contains   places-to-b-and-h
Change the action to "Delete Message".
Select "Manually Run" from the dropdown at the top.
Click OK.

Select the filter in the list, make sure "Inbox" is selected at the bottom, and click "Run Now". This should delete all the bugspam. You can then delete the filter.

Gerv