[mapserver-users] Does Mapserver utilise Spatialite spatial index correctly?
Jeff McKenna
jmckenna at gatewaygeomatics.com
Mon Feb 13 05:26:10 PST 2012
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/
More information about the MapServer-users
mailing list