690707 - TB7 sorts messages by From too slowly, if "show only display names" is enabled and many contacts are defined in addressbook

Status: RESOLVED WORKSFORME

(Thunderbird :: Folder and Message Lists, defect)

Description

[Avner Falk]

User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:6.0.2) Gecko/20100101 Firefox/6.0.2
Build ID: 20110902133214

Steps to reproduce:

Installed TB7b3.


Actual results:

Even with the latest Beta of TB7, the sorting of messages in a given folder by the sender's name takes an inordinate amount of time (from 5 to 30 seconds, depending on the number of messages in the folder). In TB3 it takes less than a second. This is a serious problem which will prevent users from upgrading to TB7 or will make them revert to TB3.


Expected results:

TB7 should sort messages by the From header as fast as TB3.

Comment 1

[Avner Falk]

P.S. If the sorting of messages in the From column were done by the To: header, as in TB3, rather than by the Display Name, it would probably be just as fast.

Comment 2

[Jim Porter (:squib)]

I recall Bienvenu mentioning this in a patch, so CCing him here. For what it's worth, I don't see any speed issues with sorting.

Comment 3

[David :Bienvenu]

this is caused by Bug 672022 - it should only be the first sort that's slow, and that slowness is directly proportional to the total number of addresses in your address books. If you turn off "show only display names", sorting should revert to its earlier performance (tools, options, advanced, reading and display). And if you make changes to your address book, that will make us have to re-recache the display name and make sorting slow again the next time.

Fix for this will have to wait for a new AB backend that gives us a real index so we can look up display names via an index. Mike, this is the particular problem I was talking about where we need an index of the lower case version of all the e-mail addresses in a card.

Comment 4

[Avner Falk]

Many thnaks, David.

Comment 5

[Avner Falk]

Er... Thanks :-)

Comment 6

[Mike Conley (:mconley) (:⚙️)]

> Mike, this is the particular problem I was talking about where we need an index of 
> the lower case version of all the e-mail addresses in a card.

*nods*, noted.

Comment 7

[WADA:World Anti-bad-Duping Agency]

To bug opener:
Same as or similar to Bug 672022?
Do you agree with duping of your report to that bug?
See also Bug 695327 in which the Bug 672022 is pointed/mentioned.

Comment 10

[Wayne Mery (:wsmwk)]

Avner does this still reproduce for you with version 102 or 115?

Comment 11

[Avner Falk]

Wayne: I have switched to Betterbird 115.5.1 and it is bug free.

Comment 12

[Wayne Mery (:wsmwk)]

I am not able to reproduce with nightly build, 30k message virtual folder and almost 3,000 contacts