[mapserver-users] Does Mapserver utilise Spatialite spatial index correctly?

[Jeff McKenna]

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/