From f29300bf1a57a96dccacc20daade126dbea42f74 Mon Sep 17 00:00:00 2001
From: Tom Hughes <tom@compton.nu>
Date: Mon, 7 Jan 2008 00:33:54 +0000
Subject: [PATCH] Stop trying to report on the number of ways with tags because
 (a) almost all ways have tags so it isn't very interesting and (b) it locks
 up the API every night as it involved a join to a MyISAM table.

---
 script/statistics | 2 --
 1 file changed, 2 deletions(-)

diff --git a/script/statistics b/script/statistics
index 0d300f706..e76028114 100755
--- a/script/statistics
+++ b/script/statistics
@@ -19,7 +19,6 @@ begin
   tracepoint_count = Tracepoint.count()
   node_count = Node.count(:conditions => "visible = true")
   way_count = Way.count(:conditions => "visible = true")
-  tagged_way_count = Way.count(:conditions => "visible = true AND EXISTS (SELECT * FROM current_way_tags WHERE id = current_ways.id AND k <> 'created_by')")
   relation_count = Relation.count(:conditions => "visible = true")
 
   puts "<table>"
@@ -27,7 +26,6 @@ begin
   puts "<tr><td>Number of uploaded GPS points</td><td>#{tracepoint_count}</td></tr>"
   puts "<tr><td>Number of nodes</td><td>#{node_count}</td></tr>"
   puts "<tr><td>Number of ways</td><td>#{way_count}</td></tr>"
-  puts "<tr><td>Number of ways with tags</td><td>#{tagged_way_count}</td></tr>"
   puts "<tr><td>Number of relations</td><td>#{relation_count}</td></tr>"
   puts "</table>"
 
-- 
2.43.2