From 94aa1b52822c599229db9933c4d5678484afe467 Mon Sep 17 00:00:00 2001 From: rvelices Date: Fri, 25 Apr 2008 01:00:39 +0000 Subject: - minor sql query optimizations git-svn-id: http://piwigo.org/svn/trunk@2308 68402e56-0260-453c-a942-63ccdbb3a9ee --- include/functions_tag.inc.php | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'include/functions_tag.inc.php') diff --git a/include/functions_tag.inc.php b/include/functions_tag.inc.php index fff7cdf90..7bd5d8408 100644 --- a/include/functions_tag.inc.php +++ b/include/functions_tag.inc.php @@ -49,7 +49,8 @@ SELECT tag_id, COUNT(DISTINCT(it.image_id)) counter ' WHERE' ).' - GROUP BY tag_id'; + GROUP BY tag_id + ORDER BY NULL'; $tag_counters = simple_hash_from_query($query, 'tag_id', 'counter'); if ( empty($tag_counters) ) @@ -243,6 +244,11 @@ SELECT id, name, url_name, count(*) counter ORDER BY counter DESC LIMIT 0,'.$max_tags; } + else + { + $query .= ' + ORDER BY NULL'; + } $result = pwg_query($query); $tags = array(); -- cgit v1.2.3