Change Details

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 Progress: [] s1 [x] s2 [x] s3 [x] s4 [x] s5 [x] s6 [x] s7 [x] s8 [x] labtestwiki

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 Progress: [x] s1 [x] s2 [x] s3 [x] s4 [x] s5 [x] s6 [x] s7 [x] s8 [x] labtestwiki

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 Progress: [x] s1 [x] s2 [x] s3 [x] s4 [x] s5 [x] s6 [x] s7 [x] s8 [x] labtestwiki