From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sun, 16 Dec 2012 11:02:50 +0000 (+0100)
Subject: increase penalty for search requests
X-Git-Tag: deploy~657
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/c29bc2cf3198249e20e2c749ac7363de12e93b60?hp=c678e0454117586f1dd5365a6d52cfa924358aa9

increase penalty for search requests
---

diff --git a/utils/cron_banip.py b/utils/cron_banip.py
index 4cc50fc5..12595b21 100755
--- a/utils/cron_banip.py
+++ b/utils/cron_banip.py
@@ -107,7 +107,7 @@ cur = conn.cursor()
 cur.execute("""
   SELECT ipaddress, max(count) FROM
    ((SELECT * FROM
-     (SELECT ipaddress, sum(CASE WHEN type = 'search' THEN 2 ELSE 1 END) as count FROM new_query_log 
+     (SELECT ipaddress, sum(CASE WHEN type = 'search' THEN 3 ELSE 1 END) as count FROM new_query_log
       WHERE starttime > now() - interval '1 hour' GROUP BY ipaddress) as i
    WHERE count > %s)
    UNION