173567 - Default to "exact match" for email search in queries

Status: VERIFIED FIXED

(Bugzilla :: Query/Bug List, defect)

Description

[Gervase Markham [:gerv]]

Substring email searches take far longer than exact match ones, and exact match
is often what people want. Also, if they put in a partial match and click
Search, they'll just get Zarro Boogs and can come back and adjust the setting,
whereas the other way round we do the expensive query regardless.

Gerv

Comment 1

[Gervase Markham [:gerv]]

Together with the changes for bug 173573, the new default query will be:

bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&product=Browser&
product=MailNews&emailassigned_to1=1&emailassigned_to2=1&emailreporter2=1&
emailqa_contact2=1&emailtype1=exact&emailtype2=exact&order=%22Importance%22&
keywords_type=allwords

Should the email change be b.m.o.-specific? I seem to remember mpt having a view
on this when he redesigned the page...

Gerv

Comment 2

[Gervase Markham [:gerv]]

An analysis of 17 killed queries showed this problem in 5 of them.

See also bug 173689.

Gerv

Comment 3

[Joel Peshkin]

This is only a drop in the bucket.... it needs to happen in conjunction with bug
127200

Comment 4

[Gervase Markham [:gerv]]

This has now been done on b.m.o.

Gerv

Comment 5

[Gervase Markham [:gerv]]

I'm going to change this; email should probably stay substring as default for
installations with fewer capacity problems than b.m.o.

Gerv

Comment 6

[David G King]

From recent usage, I'm going to Verify this.