<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><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">mapserver-users-request@lists.osgeo.org</a> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-family: Helvetica; font-size: medium; color: rgb(127, 127, 127); "><b>From:<span class="Apple-converted-space"> </span></b></span><span style="font-family: Helvetica; font-size: medium; ">Stephen Woodbridge <<a href="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</a>><br></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-family: Helvetica; font-size: medium; color: rgb(127, 127, 127); "><b>Date:<span class="Apple-converted-space"> </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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-family: Helvetica; font-size: medium; color: rgb(127, 127, 127); "><b>To:<span class="Apple-converted-space"> </span></b></span><span style="font-family: Helvetica; font-size: medium; "><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-family: Helvetica; font-size: medium; color: rgb(127, 127, 127); "><b>Subject:<span class="Apple-converted-space"> </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">Jukka.Rahkonen@mmmtike.fi</a><span class="Apple-converted-space"> </span><<a href="mailto:Jukka.Rahkonen@mmmtike.fi">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">mapserver-users@lists.osgeo.org</a><br></blockquote><blockquote type="cite"><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></blockquote></span><br class="Apple-interchange-newline"></blockquote></div><br></div></body></html>