<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="GENERATOR" content="MSHTML 8.00.6001.19154">
</head>
<body>
<div><font size="2" face="Arial"><span class="874070615-10022012">Hi,</span></font></div>
<div><font size="2" face="Arial"><span class="874070615-10022012"></span></font> </div>
<div><font size="2" face="Arial"><span class="874070615-10022012">GDAL was made to utilise Spatialite spatial index effectively if it exists with ticket</span></font></div>
<div><font size="2" face="Arial"><span class="874070615-10022012"><a href="http://trac.osgeo.org/gdal/ticket/4212">http://trac.osgeo.org/gdal/ticket/4212</a></span></font></div>
<div><font size="2" face="Arial"><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 size="2" face="Arial"><span class="874070615-10022012"></span></font> </div>
<div><font size="2" face="Arial"><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 size="2" face="Arial"><span class="874070615-10022012"></span></font> </div>
<div><font size="2" face="Arial"><span class="874070615-10022012">-Jukka Rahkonen-</span></font></div>
</body>
</html>