From 82aaf647cbd530195dee7408a702171be0457e19 Mon Sep 17 00:00:00 2001 From: Sam Reed Date: Fri, 14 Jan 2011 23:20:42 +0000 Subject: [PATCH] More query reorganisation, in an attempt to be index friendly --- includes/api/ApiQueryCategoryMembers.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/includes/api/ApiQueryCategoryMembers.php b/includes/api/ApiQueryCategoryMembers.php index 5ac888ef3f..6f005dc310 100644 --- a/includes/api/ApiQueryCategoryMembers.php +++ b/includes/api/ApiQueryCategoryMembers.php @@ -93,9 +93,7 @@ class ApiQueryCategoryMembers extends ApiQueryGeneratorBase { $this->addTables( array( 'page', 'categorylinks' ) ); // must be in this order for 'USE INDEX' - $this->setContinuation( $params['continue'], $params['dir'] ); $this->addWhereFld( 'cl_to', $categoryTitle->getDBkey() ); - $this->addWhereFld( 'cl_type', $params['type'] ); // Scanning large datasets for rare categories sucks, and I already told @@ -129,6 +127,8 @@ class ApiQueryCategoryMembers extends ApiQueryGeneratorBase { $this->addWhere( 'cl_from=page_id' ); + $this->setContinuation( $params['continue'], $params['dir'] ); + $limit = $params['limit']; $this->addOption( 'LIMIT', $limit + 1 ); -- 2.20.1