Closed Bug 985351 Opened 7 years ago Closed 3 years ago

Browser unresponsive when I perform "Clear Recent History" everything when there are many history entries

Categories

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

23 Branch
x86_64
Windows 7
defect

Tracking

()

RESOLVED WORKSFORME
Tracking Status
firefox28 --- affected
firefox29 --- affected
firefox30 --- affected
firefox31 --- affected
firefox-esr24 --- affected

People

(Reporter: alice0775, Unassigned)

References

(Blocks 1 open bug)

Details

(Keywords: hang, perf, regression, Whiteboard: [fxsearch][fxperf:p3])

Sample place.sqlite is attachment 8384288 [details] which contains 49068 history entries

Steps To Reproduce:
1. Open History > "Clear Recent History..."
2. Select Everything
3. Check "Browsing & Download History"
4. Click "Clear "Now"

Actual Results:
Browser become unresponsive


Firefiox22  : 12sec
Firefiox23-31.0a1  : It is not finished even if I wait for 5 minutes. I gave it up.
Blocks: PlacesIO
Priority: -- → P2
Whiteboard: [fxsearch][fxperf]
Hey mak, would Clear Recent History be using the new async APIs yet?
Flags: needinfo?(mak77)
Whiteboard: [fxsearch][fxperf] → [fxsearch][fxperf:p3]
(In reply to Mike Conley (:mconley) (:⚙️) (Totally backlogged on reviews and needinfos) from comment #1)
> Hey mak, would Clear Recent History be using the new async APIs yet?

It does. Actually I didn't notice this report was from 4 years ago when I marked it... We should recheck numbers and profile if necessary. We have the attachment here so it should be easy to reproduce and profile this.
Flags: needinfo?(mak77)
Hm. I dropped the places.sqlite file into a new profile, and it seemed to be ignored. Not sure why.

Alice, do you still see that clearing history janks the whole browser?
Flags: needinfo?(alice0775)
(In reply to Mike Conley (:mconley) (:⚙️) (PTO - back May 7) from comment #3)
> Hm. I dropped the places.sqlite file into a new profile, and it seemed to be
> ignored. Not sure why.

Probably the schema version is too old to be updated :(
On latest Noghtly61.a1, It takes about 6 seconds to delete history approx. 50000 entry by using "Clear Recent History".
So, I think it is reasonable for me.

Let's mark status to "RESOLVED WORKSFORME".
Status: NEW → RESOLVED
Closed: 3 years ago
Flags: needinfo?(alice0775)
Resolution: --- → WORKSFORME
You need to log in before you can comment on or make changes to this bug.