Page MenuHomePhabricator
Differential D21465

Add missing indexes to DrydockRepositoryOperation
ClosedPublic
Actions

Authored by epriestley on Sep 17 2020, 7:08 PM.
Tags
None
Referenced Files
F13239615: D21465.id51093.diff
Wed, May 22, 5:07 AM
F13209927: D21465.diff
Fri, May 17, 2:55 AM
F13204862: D21465.diff
Wed, May 15, 1:11 AM
F13188087: D21465.diff
Sat, May 11, 5:01 AM
F13182103: D21465.diff
Thu, May 9, 7:35 PM
Unknown Object (File)
Tue, May 7, 8:12 AM
Unknown Object (File)
Sat, May 4, 12:02 AM
Unknown Object (File)
Fri, May 3, 7:00 PM
View All 66 Files
Subscribers
Restricted Owners Package

Details

Reviewers
None
Commits
rPa754c694deab: Add missing indexes to DrydockRepositoryOperation
Summary

See PHI1885. Repository operations are queryable by state and author, but neither column has a usable key. Add usable keys.

Test Plan

Ran EXPLAIN on a state query. Ran bin/storage upgrade. Ran EXPLAIN again, saw query go from a table scan to a const key lookup.

Diff Detail

Repository
rP Phabricator
Lint
Lint Not Applicable
Unit
Tests Not Applicable

Event Timeline

epriestley created this revision.Sep 17 2020, 7:08 PM
Owners added a subscriber: Restricted Owners Package.Sep 17 2020, 7:08 PM
Harbormaster completed remote builds in B24907: Diff 51092.Sep 17 2020, 7:09 PM
This revision was not accepted when it landed; it landed in state Needs Review.Sep 17 2020, 7:09 PM
epriestley requested review of this revision.
Closed by commit rPa754c694deab: Add missing indexes to DrydockRepositoryOperation (authored by epriestley). · Explain Why
This revision was automatically updated to reflect the committed changes.
epriestley mentioned this in rPa754c694deab: Add missing indexes to DrydockRepositoryOperation.
epriestley added a commit: rPa754c694deab: Add missing indexes to DrydockRepositoryOperation.

Revision Contents
Changeset List

PathSize
src/
applications/
drydock/
storage/
6 lines

Diff 51093

View Options

src/applications/drydock/storage/DrydockRepositoryOperation.php

Loading...
Phabricator · Built by Phacility