fielddefs custom and obsolete should probably be indexed

NEW
Unassigned

Status

()

Bugzilla
Database
--
enhancement
2 years ago
2 years ago

People

(Reporter: dylan, Unassigned)

Tracking

({perf})

5.1.1

Details

(Reporter)

Description

2 years ago
On large sites, like BMO, custom fields can out-number non-custom fields.

Searching for fields where custom = 0 is common, and that field is not indexed. Indexing that field would provide a slight performance improvement and I fail to see the downsides.

Comment 1

2 years ago
Wouldn't custom + obsolete make more sense than custom alone? You often want active custom fields.
Severity: normal → enhancement
(Reporter)

Comment 2

2 years ago
looks like that is an even better win.
Summary: fielddefs.custom should probably be indexed → fielddefs custom and obsolete should probably be indexed
You need to log in before you can comment on or make changes to this bug.