Page MenuHomePhabricator

Review real-world query plans and performance for Jade
Open, LowPublic

Description

The JOINs between Jade tables and MediaWiki recentchanges should be reviewed as we accumulate real data in the tables. There's some potential for bad optimization and full scans, and certain filter conditions will be very sparse.

Do this task once we hit something like 1M rows.

Related Objects

StatusAssignedTask
OpenNone
OpenNone
InvalidNone
InvalidNone
Resolvedawight
Resolvedawight
Resolvedawight
Resolvedawight
OpenNone
ResolvedNone
InvalidNone
OpenNone
Resolvedawight
ResolvedHarej
OpenNone
OpenNone
Resolvedawight
OpenHarej
Resolvedawight
Resolvedawight
OpenNone
OpenNone
OpenNone
OpenHarej
OpenNone
ResolvedLadsgroup
OpenLadsgroup
Resolvedmmodell
ResolvedNone
ResolvedNone
Resolvedhashar
OpenNone
Resolvedawight
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
DuplicateHarej
InvalidNone
OpenHarej
OpenNone
ResolvedNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone

Event Timeline

awight created this task.Dec 20 2018, 5:52 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 20 2018, 5:52 PM
Marostegui triaged this task as Normal priority.
awight updated the task description. (Show Details)Dec 20 2018, 7:25 PM
Halfak lowered the priority of this task from Normal to Low.
awight removed a subscriber: awight.Mar 21 2019, 4:05 PM