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.
Are we adding the login_name field to solve Bug 218917? If so, the new nickname field may be redundant.
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.
9 months ago
Status: NEW → RESOLVED
Last Resolved: 8 months ago
Resolution: --- → FIXED
8 months ago
Depends on: 1476479
19 days ago
You need to log in before you can comment on or make changes to this bug.