Closed Bug 1469911 Opened 6 years ago Closed 6 years ago

Make user autocompletion faster

Categories

(bugzilla.mozilla.org :: General, enhancement)

Product:
bugzilla.mozilla.org
Component:
General
Version:
Production
Type:
enhancement
Priority:
Not set
Severity:
normal

Tracking

()

Status:
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.
Depends on: 1469920
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.
Blocks: 1352571
Status: NEW → RESOLVED
Closed: 6 years ago
Resolution: --- → FIXED
Depends on: 1476479
Blocks: 1383754
You need to log in before you can comment on or make changes to this bug.