jenkins-bot has submitted this change and it was merged.

Change subject: Remove about 700 unnecessary queries
......................................................................


Remove about 700 unnecessary queries

2*supported languages

Change-Id: Ib43a853631c4aaf4d7324e9566a0d9625e21a83c
---
M specials/SpecialSupportedLanguages.php
1 file changed, 7 insertions(+), 2 deletions(-)

Approvals:
  Amire80: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/specials/SpecialSupportedLanguages.php 
b/specials/SpecialSupportedLanguages.php
index 656e09f..4abc325 100644
--- a/specials/SpecialSupportedLanguages.php
+++ b/specials/SpecialSupportedLanguages.php
@@ -249,7 +249,7 @@
                $tables = array( 'page', 'revision', 'text' );
                $vars = array_merge(
                        Revision::selectTextFields(),
-                       array( 'page_title', 'page_namespace' ),
+                       Revision::selectPageFields(),
                        Revision::selectFields()
                );
                $conds = array(
@@ -263,9 +263,14 @@
 
                $users = array();
                $lb = new LinkBatch;
+               $lc = LinkCache::singleton();
 
                foreach ( $res as $row ) {
-                       $rev = new Revision( $row );
+                       $title = Title::newFromRow( $row );
+                       // Does not contain page_content_model, but should not 
matter
+                       $lc->addGoodLinkObjFromRow( $title, $row );
+
+                       $rev = Revision::newFromRow( $row );
                        $text = ContentHandler::getContentText( 
$rev->getContent() );
                        $code = strtolower( preg_replace( '!/translators$!', 
'', $row->page_title ) );
 

-- 
To view, visit https://gerrit.wikimedia.org/r/189224
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: merged
Gerrit-Change-Id: Ib43a853631c4aaf4d7324e9566a0d9625e21a83c
Gerrit-PatchSet: 2
Gerrit-Project: mediawiki/extensions/Translate
Gerrit-Branch: master
Gerrit-Owner: Nikerabbit <[email protected]>
Gerrit-Reviewer: Amire80 <[email protected]>
Gerrit-Reviewer: jenkins-bot <>

_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

Reply via email to