Nikerabbit has uploaded a new change for review.
https://gerrit.wikimedia.org/r/188981
Change subject: Add index to speed up stats queries
......................................................................
Add index to speed up stats queries
Since this table is expected to be manually maintained, I did not
create a patch and updater entry for it.
Bug: T88538
Change-Id: I759a636b6ab107b3d6d44549d0ad0b2636277631
---
M sql/contenttranslation.sql
1 file changed, 5 insertions(+), 0 deletions(-)
git pull
ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/ContentTranslation
refs/changes/81/188981/1
diff --git a/sql/contenttranslation.sql b/sql/contenttranslation.sql
index da66445..8e9f6c9 100644
--- a/sql/contenttranslation.sql
+++ b/sql/contenttranslation.sql
@@ -61,6 +61,11 @@
translation_target_language
);
+CREATE INDEX /*i*/cx_translation_languages ON /*_*/cx_translations (
+ translation_source_language,
+ translation_target_language
+);
+
CREATE UNIQUE INDEX /*i*/cx_translation_translators ON /*_*/cx_translators (
translator_user_id,
translator_translation_id
--
To view, visit https://gerrit.wikimedia.org/r/188981
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I759a636b6ab107b3d6d44549d0ad0b2636277631
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/ContentTranslation
Gerrit-Branch: master
Gerrit-Owner: Nikerabbit <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
