From 33f6f522d355744dba186cca7f9a88f18dc8a937 Mon Sep 17 00:00:00 2001 From: River Tarnell Date: Sat, 2 Jul 2005 02:10:01 +0000 Subject: [PATCH] honouring page metadata is too slow for this query --- includes/SpecialContributions.php | 13 ++++++++----- 1 file changed, 8 insertions(+), 5 deletions(-) diff --git a/includes/SpecialContributions.php b/includes/SpecialContributions.php index ab0cb109b8..9392579291 100644 --- a/includes/SpecialContributions.php +++ b/includes/SpecialContributions.php @@ -34,13 +34,16 @@ class contribs_finder { list($index, $usercond) = $this->get_user_cond(); $use_index = $this->dbr->useIndexClause($index); + #$sql = "SELECT MIN(rev_timestamp) as earliest, MAX(rev_timestamp) as latest " . + # "FROM page, revision $use_index WHERE page_id = rev_page " . + # "AND "; + + #$sql .= $usercond; + #$sql .= $this->get_namespace_cond(); + #$sql .= $this->get_minor_cond(); $sql = "SELECT MIN(rev_timestamp) as earliest, MAX(rev_timestamp) as latest " . - "FROM page, revision $use_index WHERE page_id = rev_page " . - "AND "; + "FROM revision $use_index WHERE " . $usercond; - $sql .= $usercond; - $sql .= $this->get_namespace_cond(); - $sql .= $this->get_minor_cond(); $res = $this->dbr->query($sql, "contribs_finder::get_edit_limits"); $rows = array(); while ($o = $this->dbr->fetchObject($res)) -- 2.20.1