Closed
Bug 1469911
Opened 6 years ago
Closed 6 years ago
Make user autocompletion faster
Categories
(bugzilla.mozilla.org :: General, enhancement)
Tracking
()
RESOLVED
FIXED
People
(Reporter: dylan, Assigned: dylan)
References
(Depends on 1 open bug, Blocks 1 open bug, Regressed 1 open bug)
Details
Right now, when you type (For instance) :bz into a autocompletion field, bugzilla has to scan 600,000 rows. We can make this better by making a few tweaks to the database: 1) Add a nickname field that captures (the first) :colon nick in the realname field 2) Add a fulltext index on the realname field 3) Make all user autocompletion requests either be prefix matches ('foo LIKE "Boris%"') or fulltext searches.
Comment 1•6 years ago
|
||
Are we adding the login_name field to solve Bug 218917? If so, the new nickname field may be redundant.
Assignee | ||
Comment 2•6 years ago
|
||
No, bug 218917 isn't how we'll be solving the username problem. This is a stepping stone to https://bugzilla.mozilla.org/show_bug.cgi?id=1372631 and related bugs. This change doesn't yet require a change in user behavior, it just lets me have bugzilla respond to autocomplete requests faster.
Assignee | ||
Updated•6 years ago
|
Status: NEW → RESOLVED
Closed: 6 years ago
Resolution: --- → FIXED
You need to log in
before you can comment on or make changes to this bug.
Description
•