Erase functions in nsNavHistoryExpire iterate all history visits many times

RESOLVED FIXED

Status

()

Firefox
Bookmarks & History
P3
normal
RESOLVED FIXED
10 years ago
6 years ago

People

(Reporter: Ondrej Brablc, Unassigned)

Tracking

({perf})

Trunk
Points:
---
Dependency tree / graph
Bug Flags:
blocking-firefox3 -

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

10 years ago
Bug 412438 fixed duplicate IDs in SQL queries, however, it can still be improved - at the moment we get an array of all visits in FindVisits. This array is later 5 times iterated to build different lists of IDs which are used to delete data.

It should be possible to iterate this array only once, actually it should be done at the moment when we are fetching the data from the database and all the lists should be produced here. We can probably go as far as not creating the array at all, we should only produce the lists.

However, it is questionable, whether we should do this, or avoid calling FindVisits at all as suggested in bug 409723.

Comment 1

10 years ago
yes, i've not changed all functions to use a different array because this has still to be investigated, probably the best thing would be replace or remove findvisits but if that's not possible we should do this. 

As you said the array could be changed to a simple PRInt64 array of place ids (checked only once) and passed it to clear functions insted of passing the array of results. 

At least we have mitigated the huge queries problem.

Comment 2

10 years ago
marking as perf, this is however not blocking imho
Keywords: perf

Comment 3

10 years ago
notice that it's true that visits are looped in each function, but it's also true that they are filtered differently (this filtering happens before query and dupes filtering, so it could improve query speed, or be totally useless, should have real numbers on this).
OS: Windows XP → All
Priority: -- → P3
Hardware: PC → All
(Reporter)

Updated

10 years ago
Flags: blocking-firefox3?
This will not block the final release of Firefox 3.
Flags: blocking-firefox3? → blocking-firefox3-
(Reporter)

Updated

9 years ago
Depends on: 423671
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
Component: Places → Bookmarks & History
QA Contact: places → bookmarks
fixed with async expiration bug 520165
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Depends on: 520165
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.