<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style id="owaParaStyle" type="text/css">P {margin-top:0;margin-bottom:0;}</style>
</head>
<body ocsi="0" fpstyle="1">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">There is no native support for Spatialite in MapServer, it's all through GDAL/OGR.<br>
<br>
Steve<br>
<br>
<div style="font-family: Times New Roman; color: rgb(0, 0, 0); font-size: 16px;">
<hr tabindex="-1">
<div style="direction: ltr;" id="divRpF434649"><font color="#000000" face="Tahoma" size="2"><b>From:</b> mapserver-users-bounces@lists.osgeo.org [mapserver-users-bounces@lists.osgeo.org] on behalf of Rahkonen Jukka [Jukka.Rahkonen@mmmtike.fi]<br>
<b>Sent:</b> Friday, February 10, 2012 9:12 AM<br>
<b>To:</b> 'mapserver-users@lists.osgeo.org'<br>
<b>Subject:</b> [mapserver-users] Does Mapserver utilise Spatialite spatial index correctly?<br>
</font><br>
</div>
<div></div>
<div>
<div><font face="Arial" size="2"><span class="874070615-10022012">Hi,</span></font></div>
<div><font face="Arial" size="2"><span class="874070615-10022012"></span></font> </div>
<div><font face="Arial" size="2"><span class="874070615-10022012">GDAL was made to utilise Spatialite spatial index effectively if it exists with ticket</span></font></div>
<div><font face="Arial" size="2"><span class="874070615-10022012"><a href="http://trac.osgeo.org/gdal/ticket/4212" target="_blank">http://trac.osgeo.org/gdal/ticket/4212</a></span></font></div>
<div><font face="Arial" size="2"><span class="874070615-10022012">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.</span></font></div>
<div><font face="Arial" size="2"><span class="874070615-10022012"></span></font> </div>
<div><font face="Arial" size="2"><span class="874070615-10022012">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?</span></font></div>
<div><font face="Arial" size="2"><span class="874070615-10022012"></span></font> </div>
<div><font face="Arial" size="2"><span class="874070615-10022012">-Jukka Rahkonen-</span></font></div>
</div>
</div>
</div>
</body>
</html>