328329 - Optimize history database indices

Status: RESOLVED FIXED

(Firefox :: Bookmarks & History, defect, P4)

Description

[Brett Wilson]

It looks like we aren't using host or visit count indices right now, but we might in the future. Also, and index should be created to optimize autocomplete queries. Once we have a good idea of the types of common queries we need to support, we should review our indices and add/remove as necessary.

Comment 1

[Brett Wilson]

I think this is pretty much done. I made sure autocomplete and expiration work well. If other cases are too slow, we can resolve those as they come up.

Comment 2

[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