293643 - Beyond-pathetic history performance makes Firefox 100% unusable

Status: RESOLVED DUPLICATE of bug 223476

(Firefox :: Bookmarks & History, defect)

Description

[Richard Mlynarik]

User-Agent:       Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en-au) AppleWebKit/312.1 (KHTML, like Gecko) Safari/312
Build Identifier: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7.7) Gecko/20050414 Firefox/1.0.3

I have a 45mb history.dat which I copied over from my Mozilla 1.7.3 installation.
(No, I didn't use any sort of import tool.)

No, I am ****NOT**** interested in truncating my history file for your convenience.
This is a small file by the standards of the 1gb 1ghz machine on which the browser runs;
this is not 1990.

Yes, I have read some previous bug reports about how totally Mork sucks.
https://bugzilla.mozilla.org/show_bug.cgi?id=241438

I believe this is a separate and even worse problem.

Periodically -- approximately but not precisely every fourth or fifth time I
navigate forward (click on a link) or accidentally mouse over the "Go" (ie history)
item, the browser COMPLETELY LOCKS UP for UP TO FIVE MINUTES AT A TIME.

A backtrace sample obtained via the Apple "Activity Monitor" application
shows the browser is always looping inside some utterly hideous C++/Mork
enumeration **** (nsGlobalHistory::GetRootDayQueries, nsMdbTableEnumerator::HasMoreElements, 
nsGlobalHistory::SearchEnumerator::IsResult, etc) which seems to be 50% of the overhead, and 50% 
more
of the overhead appears to be in "PR_ExplodeTime".

Firefox is completely unusable for me.  Hanging for five minutes every couple of
minutes is simply unacceptable under any circumstances.


Reproducible: Always

Steps to Reproduce:
See above.


Actual Results:  
Firefox hangs for minutes at a time

Expected Results:  
Pull down menu should be displayed instantaneously or link should be
followed instantaneously.

Comment 1

[Richard Mlynarik]

Attachment: Hideous backtrace #1

Comment 2

[Richard Mlynarik]

Attachment: Hideous backtrace #2

Comment 3

[Jo Hermans]

It will be fixed by bug 241438, b/c we're switching to SQLite as the backend
format. See <http://wiki.mozilla.org/Mozilla2:Unified_Storage>.

see bug 223476 and bug 266627

*** This bug has been marked as a duplicate of 223476 ***