[Mapbender-commits] r4460 - trunk/mapbender/resources/db/update

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2009-07-31 04:43:04 -0400 (Fri, 31 Jul 2009)
New Revision: 4460

Modified:
   trunk/mapbender/resources/db/update/update_2.7.sql
Log:
added index on wms for better performance

Modified: trunk/mapbender/resources/db/update/update_2.7.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_2.7.sql	2009-07-30 15:10:07 UTC (rev 4459)
+++ trunk/mapbender/resources/db/update/update_2.7.sql	2009-07-31 08:43:04 UTC (rev 4460)
@@ -215,5 +215,16 @@
   ON mb_monitor
   FOR EACH ROW
   EXECUTE PROCEDURE mb_monitor_after();
+  
+  
+-- Index: idx_wms_id
 
+-- DROP INDEX idx_wms_id;
+
+CREATE INDEX idx_wms_id
+  ON wms
+  USING btree
+  (wms_id);
+  
+
 ---------------------------------------------MONITORING END