324428 - Check DB sorting performance

Status: RESOLVED FIXED

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

Description

[Brett Wilson]

The current implementation has a "SORT BY" SQL clause when doing history queries on the assumption that the database can do a faster job than we can because it has indices. Then we sort afterward, which is necessary for some things like grouping and because of internationalization issues. If the results are already mostly sorted, our second sorting will be much faster.

However, I suspect that the initial sort is not any faster than ours, so we are actually wasting time doing two sorts. Investigate this and remove the DB sorting clause if necessary.

Comment 1

[Brett Wilson]

The SORT BY clause is necessary for the max results to work. It might be good to only do this in the cases where we have max results, but sorting performance seems fine now.

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