<div>Hi,</div>
<div> </div>
<div>I just tried creating a qix file as suggested and found that the Shape file now renders 22 times faster! Fantastic advice guys. Many thanks.</div>
<div> </div>
<div>If only there was a way to prevent the TTF file being continuously accessed when displaying a symbol using a truetype font. Any further ideas at all? It kind of makes a TTF unusable.</div>
<div> </div>
<div>Best regards,</div>
<div>Jon-Paul.<br><br></div>
<div class="gmail_quote">On Thu, May 12, 2011 at 7:52 AM, Rahkonen Jukka <span dir="ltr"><<a href="mailto:Jukka.Rahkonen@mmmtike.fi">Jukka.Rahkonen@mmmtike.fi</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div style="WORD-WRAP: break-word">
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span>Hi,</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span>For clarification, it used to be rather a long time ago that the index file (.qix) was not utilised even it was present in the data folder if the LAYER DATA was given as</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span>DATA "C:\Data\WMS_DATA.shp"</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span>Index was used only if the LAYER DATA was like</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span>DATA "C:\Data\WMS_DATA"</span></font></div></span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span>However, this in old knowledge and both WMS_DATA.shp and WMS_DATA are utilising the index nowadays.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span>Gdal is using the same .qix index file system and therefore also QGIS. There is more info about gdal shapefile spatial index in <a href="http://www.gdal.org/ogr/drv_shapefile.html" target="_blank">http://www.gdal.org/ogr/drv_shapefile.html</a></span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span>The page tells also that native ESRI spatial index files (.sbn/ .sbx) are not supported.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span>-Jukka Rahkonen-</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span></span></font> </div><br>
<blockquote style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px" dir="ltr">
<div dir="ltr" lang="fi" align="left">
<hr>
<font size="2" face="Tahoma"><b>Lähettäjä:</b> <a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>] <b>Puolesta </b>Ben Madin<br>
<b>Lähetetty:</b> 12. toukokuuta 2011 4:00<br><b>Vastaanottaja:</b> <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br><b>Aihe:</b> Re: [mapserver-users] Layer rendering performance problem<br>
</font><br></div>
<div>
<div></div>
<div class="h5">
<div></div>
<div>I'm not sure whether it is still the case, but it used also to be that if you wanted to use the index, you need to name the shapefile without the .shp extension. If you used the .shp extension it wouldn't use the .qix index.</div>
<div><br></div>
<div>So maybe this is a question - Is that still the case?</div>
<div><br></div>
<div>On a similar note, does anyone know ... is the index created with shptree the same as the one created by QGIS (also a .qix file)?</div>
<div><br></div>
<div>cheers</div>
<div><br></div>
<div>Ben</div>
<div><br></div>
<div><br></div>
<div><br>
<div>
<div>On 12/05/2011, at 10:45 AM, <a href="mailto:mapserver-users-request@lists.osgeo.org" target="_blank">mapserver-users-request@lists.osgeo.org</a> wrote:</div><br>
<blockquote type="cite"><span style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; WORD-SPACING: 0px">
<div style="MARGIN: 0px"><span style="FONT-FAMILY: Helvetica; COLOR: rgb(127,127,127); FONT-SIZE: medium"><b>From:<span> </span></b></span><span style="FONT-FAMILY: Helvetica; FONT-SIZE: medium">Stephen Woodbridge <<a href="mailto:woodbri@swoodbridge.com" target="_blank">woodbri@swoodbridge.com</a>><br>
</span></div>
<div style="MARGIN: 0px"><span style="FONT-FAMILY: Helvetica; COLOR: rgb(127,127,127); FONT-SIZE: medium"><b>Date:<span> </span></b></span><span style="FONT-FAMILY: Helvetica; FONT-SIZE: medium">11 May 2011 11:53:34 PM AWST<br>
</span></div>
<div style="MARGIN: 0px"><span style="FONT-FAMILY: Helvetica; COLOR: rgb(127,127,127); FONT-SIZE: medium"><b>To:<span> </span></b></span><span style="FONT-FAMILY: Helvetica; FONT-SIZE: medium"><a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
</span></div>
<div style="MARGIN: 0px"><span style="FONT-FAMILY: Helvetica; COLOR: rgb(127,127,127); FONT-SIZE: medium"><b>Subject:<span> </span></b></span><span style="FONT-FAMILY: Helvetica; FONT-SIZE: medium"><b>Re: [mapserver-users] Layer rendering performance problem</b><br>
</span></div><br><br>look at the mapserver utilities:<br><br>shptree myshapefile<br><br>This creates a spatial index (*.qix) and you should create one for every shapefile you are using.<br><br>On Linux this will do the trick:<br>
<br>find /path/data -name \*.shp -exec shptree {} \;<br><br>If the .qix file is missing on every draw mapserver must create one on the fly in memory and the it throws it away.<br><br>-Steve W<br><br>On 5/11/2011 11:47 AM, Jon-Paul Dobson wrote:<br>
<blockquote type="cite">Hi Jukka,<br></blockquote>
<blockquote type="cite">Thanks for getting back to me so quickly. No I haven't tried this. How<br></blockquote>
<blockquote type="cite">is this done and what is the benefit? Aren't Shape files already indexed?<br></blockquote>
<blockquote type="cite">Regards,<br></blockquote>
<blockquote type="cite">Jon-Paul.<br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite">On Wed, May 11, 2011 at 4:41 PM, Rahkonen Jukka<br></blockquote>
<blockquote type="cite"><<a href="mailto:Jukka.Rahkonen@mmmtike.fi" target="_blank">Jukka.Rahkonen@mmmtike.fi</a><span> </span><<a href="mailto:Jukka.Rahkonen@mmmtike.fi" target="_blank">mailto:Jukka.Rahkonen@mmmtike.fi</a>>> wrote:<br>
</blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"> Hi,<br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"> No answers but a question back. Have you created spatial index<br></blockquote>
<blockquote type="cite"> (.qix) for your shapefiles with shptree?<br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"> -Jukka Rahkonen-<br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"> Jon-Paul Dobson wrote:<br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"> > Hi,<br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"> > Whenever I display a layer based on a Shape file I notice that<br></blockquote>
<blockquote type="cite"> the Shape<br></blockquote>
<blockquote type="cite"> file is accessed constantly. This makes rendering extremely slow when<br></blockquote>
<blockquote type="cite"> compared to, for example, ESRI ArcIMS which appears to cache the<br></blockquote>
<blockquote type="cite"> Shape file.<br></blockquote>
<blockquote type="cite"> Is there an equivalent caching mechanism for Map Server? ArcIMS seems to<br></blockquote>
<blockquote type="cite"> render an order of magnitude faster when the number of symbols runs<br></blockquote>
<blockquote type="cite"> into the<br></blockquote>
<blockquote type="cite"> 1000s<br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"> > Similarly, whenever I display layer symbols using a truetype font<br></blockquote>
<blockquote type="cite"> I notice<br></blockquote>
<blockquote type="cite"> that the .ttf file is accessed for every symbol. This makes rendering<br></blockquote>
<blockquote type="cite"> appallingly slow. Is there also any caching mechanism to prevent this?<br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"> > Any insight anyone can give would be much appreciated.<br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"> Best regards,<br></blockquote>
<blockquote type="cite"> Jon-Paul.<br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite"><br></blockquote>
<blockquote type="cite">_______________________________________________<br></blockquote>
<blockquote type="cite">mapserver-users mailing list<br></blockquote>
<blockquote type="cite"><a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br></blockquote>
<blockquote type="cite"><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></blockquote></span><br></blockquote></div><br></div>
</div></div></blockquote></div><br>_______________________________________________<br>mapserver-users mailing list<br><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
<br></blockquote></div><br>