From a360518cfbda4a30bac82f994f36cefbae93f692 Mon Sep 17 00:00:00 2001 From: Domas Mituzas Date: Sat, 12 Nov 2005 15:34:07 +0000 Subject: [PATCH] do not join revision for pages not touched, saves some cpu and i/o --- includes/SpecialRecentchangeslinked.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/includes/SpecialRecentchangeslinked.php b/includes/SpecialRecentchangeslinked.php index fbb745b79b..8c5e98930a 100644 --- a/includes/SpecialRecentchangeslinked.php +++ b/includes/SpecialRecentchangeslinked.php @@ -72,7 +72,7 @@ function wfSpecialRecentchangeslinked( $par = NULL ) { rev_user_text,rev_timestamp,rev_minor_edit, page_is_new FROM $categorylinks, $revision, $page - WHERE rev_timestamp > '{$cutoff}' + WHERE rev_timestamp > '{$cutoff}' AND page_timestamp > '{$cutoff}' {$cmq} AND rev_page=page_id AND cl_from=page_id -- 2.20.1