From 726594645ccd3906e39c6d8be973b2ac2d4bffd2 Mon Sep 17 00:00:00 2001 From: Piotr Przybylski Date: Tue, 16 Aug 2011 22:17:23 +0200 Subject: [PATCH] Optimize tracking query, only the first row is needed --- libraries/Tracker.class.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/libraries/Tracker.class.php b/libraries/Tracker.class.php index e89c3fce92..aad5319480 100644 --- a/libraries/Tracker.class.php +++ b/libraries/Tracker.class.php @@ -563,7 +563,7 @@ class PMA_Tracker $sql_query .= " AND `table_name` = '" . PMA_sqlAddSlashes($tablename) ."' "; } $sql_query .= " AND `version` = '" . PMA_sqlAddSlashes($version) ."' ". - " ORDER BY `version` DESC "; + " ORDER BY `version` DESC LIMIT 1"; $mixed = PMA_DBI_fetch_array(PMA_query_as_controluser($sql_query)); -- 2.11.4.GIT