Page MenuHomePhabricator

Add a missing table key to improve performance of "Recently Completed Tasks" query
ClosedPublic

Authored by epriestley on Aug 19 2016, 6:32 PM.
Tags
None
Referenced Files
Unknown Object (File)
Sun, Mar 10, 2:51 PM
Unknown Object (File)
Feb 16 2024, 11:41 AM
Unknown Object (File)
Feb 11 2024, 1:17 PM
Unknown Object (File)
Jan 29 2024, 5:38 PM
Unknown Object (File)
Jan 25 2024, 6:42 PM
Unknown Object (File)
Dec 26 2023, 6:32 AM
Unknown Object (File)
Dec 16 2023, 6:16 AM
Unknown Object (File)
Dec 15 2023, 1:40 AM
Subscribers
None

Details

Summary

Fixes T11490. Currently, this query can not use a key and the table size may be quite large.

Adjust the query so it can use a key for both selection and ordering, and add that key.

Test Plan

Ran EXPLAIN on the old query in production, then added the key and ran EXPLAIN on the new query. Saw key in use, and "rows" examined drop from 29,273 to 15.

Diff Detail

Repository
rP Phabricator
Lint
Lint Not Applicable
Unit
Tests Not Applicable

Event Timeline

epriestley retitled this revision from to Add a missing table key to improve performance of "Recently Completed Tasks" query.
epriestley updated this object.
epriestley edited the test plan for this revision. (Show Details)
epriestley added a reviewer: chad.
chad edited edge metadata.
This revision is now accepted and ready to land.Aug 19 2016, 6:41 PM
This revision was automatically updated to reflect the committed changes.