The changeset in OGR is in the spatialite driver so it doesn't look like a program using the OGR APIs would need to do anything special. Someone familiar with the OGR driver will have to weigh in I suspect...
Steve From: [email protected] [mailto:[email protected]] On Behalf Of Rahkonen Jukka Sent: Friday, February 10, 2012 9:36 AM To: '[email protected]' Subject: Re: [mapserver-users] Does Mapserver utilise Spatialite spatial index correctly? Hi, OK, lets put it this way: Is it sure that Mapserver is firing the BBOX query so that GDAL/OGR understands to follow the path that is implemented in http://trac.osgeo.org/gdal/changeset/23008 instead of making an inefficient MBRIntersects() query or some other slow query? I do not believe that a user like me has a possibility to check what really happens with Spatialite like I can do with PostGIS and Oracle because Spatialite does not collect a log file. -Jukka Rahkonen- Lime, Steve D (DNR) wrote: There is no native support for Spatialite in MapServer, it's all through GDAL/OGR. Steve ________________________________ From: [email protected] [[email protected]] on behalf of Rahkonen Jukka [[email protected]] Sent: Friday, February 10, 2012 9:12 AM To: '[email protected]' 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-
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
