Page MenuHomePhabricator

Add an index on harbormaster_buildlog.buildTargetPHID
Closed, ResolvedPublic

Description

We need a DB patch that does this:

CREATE INDEX harbormasterTargetKey ON harbormaster_buildlog (buildTargetPHID);

This reduces query times on this table for the build view controller from 1.57 seconds to 0.01 seconds (or less).

Event Timeline

hach-que raised the priority of this task from to Needs Triage.
hach-que updated the task description. (Show Details)
hach-que added a project: Harbormaster.
hach-que added subscribers: hach-que, epriestley.