Page MenuHomePhabricator

Don't create pagetriage_page_tags unless we need to
Open, Needs TriagePublic

Description

I noticed that for redirects, for example, there are rows in the pagetriage_page_tags table for category count, citation count, and even AfC state. This information is not exposed in the interface for redirects because they aren't applicable, hence we probably shouldn't store them in the first place. Similarly drafts and user pages shouldn't have category count, etc.

It is worth noting that the values for these specific tags are small integers, but they are stored as a VARBINARY (ptrpt_value).

Event Timeline

Restricted Application added a project: Growth-Team. · View Herald TranscriptJul 25 2019, 2:18 AM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
MusikAnimal renamed this task from Don't create rows in pagetriage_page_tag unless you have to to Don't create pagetriage_page_tags unless we need to.Jul 25 2019, 2:19 AM
MusikAnimal updated the task description. (Show Details)
kostajh moved this task from Inbox to Triaged but Future on the Growth-Team board.
kostajh added a subscriber: kostajh.

Thanks for filing this. Seems worth addressing, but not something Growth-Team will work on in the short-to-medium term.