Resolves T5895. This reduces page load times significantly when looking at builds.
Details
Details
- Reviewers
epriestley - Group Reviewers
Blessed Reviewers - Maniphest Tasks
- T5895: Add an index on harbormaster_buildlog.buildTargetPHID
- Commits
- Restricted Diffusion Commit
rP6f85c22faffd: Create an index on harbormaster_buildlog to reduce page load times
Viewed a build, saw the page load a lot faster.
Diff Detail
Diff Detail
- Repository
- rP Phabricator
- Lint
Lint Skipped - Unit
Tests Skipped
Event Timeline
Comment Actions
- By convention, prefer to write this like other key patches (see below).
- Prefer to provide an explicit key name.
- Provide a database name explicitly.
I think this should work:
ALTER TABLE {$NAMESPACE}_harbormaster.harbormaster_buildlog
ADD KEY `key_buildtarget` (buildTargetPHID);