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

[Rahkonen Jukka]

 Even Rouault wrote:

>
>> I've commited improvements in GDAL trunk for both points (
>> http://trac.osgeo.org/gdal/changeset/23944 and
>> http://trac.osgeo.org/gdal/changeset/23945 ) that make the above request go
>> from 1.7 sec to 0.54 sec . I don't think there's any more significant speed
>> gain to expect now (at least on OGR side).

> Actually, I found a new improvement (committed in
> http://trac.osgeo.org/gdal/changeset/23946) that make the query time go down
> to 0.07 sec (*) ! There was a slowness when opening the layer due to the
> presence of an ORDER BY clause in the DATA string, that was evaluated before
> setting the spatial filter.

> (*) For comparison, I translated your database to Postgis, and set-up the
> connection mapfile to use that Postgis database (still through OGR, not the
> MapServer Postgis backend). The same request with OGR PG is run in 0.18 sec.

Awesome!  About 25 times faster in the evening than it was in the morning. My opinion is that because Spatialite seems to be, at least in this case, more that two times faster backend for Mapserver than PostGIS it should lead to some intensive and controlled testing now.

Regards,

-Jukka Rahkonen-