175334 - Make default owner search "begins with" rather than "is"

Status: RESOLVED INCOMPLETE

(Bugzilla :: Query/Bug List, enhancement, P3)

Description

[selmer (gone)]

A change is coming that will make bug owner searches default to exact matches. 
Most names are unique without the @foo.bar portion, so changing the default to
"begins with" might alleviate performance problems without reducing the
convenience of the "contains" default.  

This recommendation is only viable if the performance of "begins with" is near
that of "is" or at least sufficiently better than "contains" to be acceptable. 
All the while that I used the default "contains" setting, I really meant "begins
with" anyway.  This might allow most people to switch to the new setup without
even knowing that anything had changed.

Comment 1

[Gervase Markham [:gerv]]

bbaetz: could this be done using a ^Foo regexp? And would it perform on a par
with exact match, or much worse?

Gerv

Comment 2

[Bradley Baetz (:bbaetz)]

We'd want to use |LIKE foo%|, which is probably more efficent. Also, since the
start of the string is fixed, the db can use an index to do the lookup.

Comment 3

[Gervase Markham [:gerv]]

I'm not going to get to this any time soon.

Gerv

Comment 4

[Dave Miller [:justdave]]

Bugzilla 2.20 feature set is now frozen as of 15 Sept 2004.  Anything flagged
enhancement that hasn't already landed is being pushed out.  If this bug is
otherwise ready to land, we'll handle it on a case-by-case basis, please set the
blocking2.20 flag to '?' if you think it qualifies.

Comment 5

[Frédéric Buclin]

What do you mean by "default owner"? Which page, which field??