Homec4science

Optimize feed query

Authored by vrana <jakubv@fb.com> on Oct 4 2012, 23:49.

Description

Optimize feed query

Summary:
This was killing us. EXPLAIN after:

idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstoryindexchronologicalKeychronologicalKey8201
1SIMPLErefrefchronologicalKeychronologicalKey8phabricator_feed.story.chronologicalKey1Using index

Test Plan: /feed/

Reviewers: epriestley

Reviewed By: epriestley

CC: aran, Korvin

Differential Revision: https://secure.phabricator.com/D3628

Details

Committed
vrana <jakubv@fb.com>Oct 5 2012, 01:07
Pushed
aubortJan 31 2017, 17:16
Parents
rPH5578ccdff27b: Expose "withAnyProjects()" in the UI
Branches
Unknown
Tags
Unknown

Event Timeline

vrana <jakubv@fb.com> committed rPH511a8bae34eb: Optimize feed query (authored by vrana <jakubv@fb.com>).Oct 5 2012, 01:07