Addshore has uploaded a new change for review.
https://gerrit.wikimedia.org/r/282208
Change subject: WikiPageEntityMetaDataLookup force use wb_epp_entity index
......................................................................
WikiPageEntityMetaDataLookup force use wb_epp_entity index
Bug: T131026
Change-Id: If2d435489d13707d27b583c658176c51048c5666
---
M lib/includes/store/sql/WikiPageEntityMetaDataLookup.php
1 file changed, 10 insertions(+), 1 deletion(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/Wikibase
refs/changes/08/282208/1
diff --git a/lib/includes/store/sql/WikiPageEntityMetaDataLookup.php
b/lib/includes/store/sql/WikiPageEntityMetaDataLookup.php
index 9d9ec26..2b788ec 100644
--- a/lib/includes/store/sql/WikiPageEntityMetaDataLookup.php
+++ b/lib/includes/store/sql/WikiPageEntityMetaDataLookup.php
@@ -178,7 +178,16 @@
// pick text via rev_text_id
$join['text'] = array( 'INNER JOIN', 'old_id=rev_text_id' );
- $res = $db->select( $tables, $fields, $this->getEppWhere(
$entityIds, $db ), __METHOD__, array(), $join );
+ $res = $db->select(
+ $tables,
+ $fields,
+ $this->getEppWhere( $entityIds, $db ),
+ __METHOD__,
+ array(
+ 'USE INDEX' => [ 'wb_entity_per_page' =>
'wb_epp_entity' ]
+ ),
+ $join
+ );
$this->releaseConnection( $db );
--
To view, visit https://gerrit.wikimedia.org/r/282208
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: If2d435489d13707d27b583c658176c51048c5666
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/Wikibase
Gerrit-Branch: master
Gerrit-Owner: Addshore <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
