Adding the namespace ID and an index between category and namespace will dramatically reduce the amount of time the database spends when processing a Linter category report when namespace is also specified.
- ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/Linter/+/755817/12/sql/patch-linter-add-namespace.sql
- Where to run those changes: all.dblist
- When to run those changes: At any time
- If the schema change is backwards compatible: Yes
- If the schema change has been tested already on some of the test/beta wikis: Tested in beta
- if the data should be made available on the labs replicas and/or dumps: Table is public