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

[Lime, Steve D (DNR)]

There is no native support for Spatialite in MapServer, it's all through GDAL/OGR.

Steve

________________________________
From: mapserver-users-bounces at lists.osgeo.org [mapserver-users-bounces at lists.osgeo.org] on behalf of Rahkonen Jukka [Jukka.Rahkonen at mmmtike.fi]
Sent: Friday, February 10, 2012 9:12 AM
To: 'mapserver-users at lists.osgeo.org'
Subject: [mapserver-users] Does Mapserver utilise Spatialite spatial index correctly?

Hi,

GDAL was made to utilise Spatialite spatial index effectively if it exists with ticket
http://trac.osgeo.org/gdal/ticket/4212
After this change ogr2ogr with -spat bounding box query is much faster.  However, when testing MS4W 3.0.4beta1 which comes with GDAL 1.9, the rendering speed of Spatialite data with Mapserver is pretty slow. It is evenly slow when zoomed out and zoomed in which makes me believe that the spatial index is perhaps not used.

Could it be that Mapserver does not utilise the improved method that was implemented for GDAL 1.9 when it is doing spatial queries from Spatialite?

-Jukka Rahkonen-
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120210/7215bee8/attachment.html