Quite an interesting discussion! Thanks guys. -jeff
On 12-02-11 5:44 PM, Even Rouault wrote:
Jukka, I've continued playing with your OSM data. I've got extra performance by adding attribute indexes, so that every field you use in a WHERE clause is indexed. For example for the roadsclose, railways and landuse layers, you could create the following indexes: CREATE INDEX idx_osm_line_railway ON osm_line(railway) CREATE INDEX idx_osm_line_highway ON osm_line(highway) CREATE INDEX idx_osm_polygon_landuse ON osm_polygon(landuse) CREATE INDEX idx_osm_polygon_leisure ON osm_polygon(leisure) CREATE INDEX idx_osm_polygon_amenity ON osm_polygon(amenity) CREATE INDEX idx_osm_polygon_aeroway ON osm_polygon(aeroway) CREATE INDEX idx_osm_polygon_natural ON osm_polygon(natural) CREATE INDEX idx_osm_polygon_highway ON osm_polygon(highway) CREATE INDEX idx_osm_polygon_waterway ON osm_polygon(waterway)
-- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
