<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style id="owaParaStyle" type="text/css">P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
</style>
<meta name="GENERATOR" content="MSHTML 8.00.6001.19154">
</head>
<body fpstyle="1" ocsi="0">
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="348002915-10022012">Hi,</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="348002915-10022012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="348002915-10022012">OK, lets put it this way:</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="348002915-10022012">Is it sure that Mapserver is firing the BBOX query so that GDAL/OGR understands to follow the path that is implemented in
<a href="http://trac.osgeo.org/gdal/changeset/23008">http://trac.osgeo.org/gdal/changeset/23008</a></span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="348002915-10022012">instead of making an inefficient MBRIntersects() query or some other slow query?</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="348002915-10022012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="348002915-10022012">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.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="348002915-10022012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="348002915-10022012">-Jukka Rahkonen-</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="348002915-10022012"></span></font> </div>
<div dir="ltr" align="left"><font size="2" face="Tahoma">Lime, Steve D (DNR) <span class="348002915-10022012"><font color="#0000ff" face="Arial"> wrote:</font></span></font><br>
</div>
<blockquote style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px" dir="ltr">
<div></div>
<div style="FONT-FAMILY: Tahoma; DIRECTION: ltr; 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" size="2" face="Tahoma"><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 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" target="_blank">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>
</div>
</div>
</div>
</blockquote>
</body>
</html>