Page MenuHomePhabricator

Use upper-case entity IDs in wb_changes table.
Closed, DuplicatePublic

Description

wb_changes still uses lowercase IDs for historical reasons. This makes it inefficient to join wb_changes against other tables with entity IDs, such as wb_changes_subscription in particular.

We should be able to simply start putting uppercase IDs into the table. Once all entries with lower case IDs have been pruned from wb_changes, we can start relying on the canonical IDs to improve ChangeDispatcher performance.

Event Timeline

daniel raised the priority of this task from to Needs Triage.
daniel updated the task description. (Show Details)
daniel added a project: Wikidata.
daniel added subscribers: Aklapper, daniel.