Paths

Table of Contentst

Add missing indexes to DrydockRepositoryOperation
ClosedPublic
Actions

Authored by epriestley on Sep 17 2020, 7:08 PM.

Tags

None

Referenced Files

	F19232801: D21465.id51093.diff
	Sun, Dec 21, 5:29 PM

	F19052438: D21465.id.diff
	Nov 28 2025, 5:12 AM

	F19041206: D21465.diff
	Nov 26 2025, 3:09 PM

	F19025903: D21465.diff
	Nov 24 2025, 9:08 AM

	F19009045: D21465.id.diff
	Nov 21 2025, 11:01 PM

	F18905862: D21465.id51093.diff
	Nov 8 2025, 4:00 PM

	F18869671: D21465.diff
	Nov 4 2025, 12:56 PM

	F18850217: D21465.diff
	Oct 30 2025, 3:07 PM

View All 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

Path

Size

src/

applications/

drydock/

storage/

DrydockRepositoryOperation.php

6 lines

Diff 51093

View Options

src/applications/drydock/storage/DrydockRepositoryOperation.php

Add missing indexes to DrydockRepositoryOperationClosedPublicActions