Catrope has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/367449 )
Change subject: Add index on oresc_probability
......................................................................
Add index on oresc_probability
Change-Id: I9bc116c43ebcab352ab66dc3d285b9a807ea755b
---
M includes/Hooks.php
M sql/ores_classification.sql
A sql/patch-ores-classification-model-class-prob-index.sql
3 files changed, 9 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/ORES
refs/changes/49/367449/1
diff --git a/includes/Hooks.php b/includes/Hooks.php
index a60ac5c..2425c7f 100644
--- a/includes/Hooks.php
+++ b/includes/Hooks.php
@@ -50,6 +50,8 @@
__DIR__ .
'/../sql/patch-ores-classification-unique-indexes.sql' );
$updater->addExtensionIndex( 'ores_model', 'oresm_model_status',
__DIR__ . '/../sql/patch-ores-model-indexes.sql' );
+ $updater->addExtensionIndex( 'ores_classification',
'oresc_model_class_prob',
+ __DIR__ .
'/../sql/patch-ores-classification-model-class-prob-index.sql' );
}
/**
diff --git a/sql/ores_classification.sql b/sql/ores_classification.sql
index 067da78..2f886af 100644
--- a/sql/ores_classification.sql
+++ b/sql/ores_classification.sql
@@ -20,3 +20,4 @@
CREATE UNIQUE INDEX /*i*/oresc_rev_model_class ON /*_*/ores_classification
(oresc_rev, oresc_model, oresc_class);
CREATE UNIQUE INDEX /*i*/oresc_rev_predicted_model ON /*_*/ores_classification
(oresc_rev, oresc_is_predicted, oresc_model);
+CREATE INDEX /*i*/oresc_model_class_prob ON /*_*/ores_classification
(oresc_model, oresc_class, oresc_probability);
diff --git a/sql/patch-ores-classification-model-class-prob-index.sql
b/sql/patch-ores-classification-model-class-prob-index.sql
new file mode 100644
index 0000000..d296d02
--- /dev/null
+++ b/sql/patch-ores-classification-model-class-prob-index.sql
@@ -0,0 +1,6 @@
+--
+-- patch-ores-classification-model-class-prob-index.sql
+--
+-- Add index on probability to ores_classification
+
+CREATE INDEX /*i*/oresc_model_class_prob ON /*_*/ores_classification
(oresc_model, oresc_class, oresc_probability);
--
To view, visit https://gerrit.wikimedia.org/r/367449
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I9bc116c43ebcab352ab66dc3d285b9a807ea755b
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/ORES
Gerrit-Branch: master
Gerrit-Owner: Catrope <r...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
