Make user autocompletion faster

RESOLVED FIXED

Status

()

RESOLVED FIXED
9 months ago
19 days ago

People

(Reporter: dylan, Assigned: dylan)

Tracking

(Depends on: 1 bug, Blocks: 1 bug)

Production
Dependency tree / graph

Firefox Tracking Flags

(Not tracked)

Details

(Assignee)

Description

9 months ago
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.
(Assignee)

Updated

9 months ago
Depends on: 1469920
Are we adding the login_name field to solve Bug 218917? If so, the new nickname field may be redundant.
(Assignee)

Comment 2

9 months 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

8 months ago
Status: NEW → RESOLVED
Last Resolved: 8 months ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.