Open Bug 1361570 Opened 8 years ago Updated 12 days ago

Add index to URL field of Repository since we search on it

Categories

(Tree Management :: Treeherder: Data Ingestion, enhancement, P3)

enhancement

Tracking

(Not tracked)

People

(Reporter: camd, Assigned: moijes12)

Details

Attachments

(1 file)

47 bytes, text/x-github-pull-request
Details | Review
We search on this field during resultset ingestion via Pulse. So we should create an index for that field.
Priority: -- → P3

@Cameron

I can see that PushLoader looks up the repository with url and active_status. So a single column index on url or a composite index using url and active_status would speed up these lookups.

I have submitted PR https://github.com/mozilla/treeherder/pull/9070 to fix this. Information on testing done has been added to the PR. Also, some deployment notes have been added too.

Assignee: nobody → moijes12
Attached file GitHub Pull Request
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: