Closed
Bug 1469911
Opened 7 years ago
Closed 7 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•7 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•7 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•7 years ago
|
Status: NEW → RESOLVED
Closed: 7 years ago
Resolution: --- → FIXED
You need to log in
before you can comment on or make changes to this bug.
Description
•