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).
Description
Description
Revisions and Commits
Revisions and Commits
| Restricted Differential Revision | Restricted Diffusion Commit |
| Status | Assigned | Task | ||
|---|---|---|---|---|
| Resolved | epriestley | T8089 Unprototype Harbormaster (v1) | ||
| Resolved | epriestley | T8097 Allow external systems to report results into Harbormaster | ||
| Resolved | None | T7419 Provide a straightforward way to create and update CI test statuses for a revision | ||
| Wontfix | epriestley | T4591 Allow Harbormaster to source GitHub pull requests as buildables | ||
| Resolved | epriestley | T5479 Unbeta Phragment | ||
| Duplicate | None | T7869 Support CircleCI webhooks for Test results (so that one can run unit tests asynchronously) | ||
| Resolved | epriestley | T1049 Implement Harbormaster | ||
| Resolved | None | T5895 Add an index on harbormaster_buildlog.buildTargetPHID |