<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19019"></HEAD>
<BODY
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=314572406-12052011>Hi,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=314572406-12052011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=314572406-12052011>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
class=314572406-12052011>DATA "C:\Data\WMS_DATA.shp"</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=314572406-12052011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=314572406-12052011>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
class=314572406-12052011>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=314572406-12052011>DATA
"C:\Data\WMS_DATA"</SPAN></FONT></DIV></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=314572406-12052011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=314572406-12052011>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
class=314572406-12052011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=314572406-12052011>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">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
class=314572406-12052011>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
class=314572406-12052011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=314572406-12052011>-Jukka Rahkonen-</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=314572406-12052011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=314572406-12052011></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 class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>Lähettäjä:</B>
mapserver-users-bounces@lists.osgeo.org
[mailto:mapserver-users-bounces@lists.osgeo.org] <B>Puolesta </B>Ben
Madin<BR><B>Lähetetty:</B> 12. toukokuuta 2011 4:00<BR><B>Vastaanottaja:</B>
mapserver-users@lists.osgeo.org<BR><B>Aihe:</B> Re: [mapserver-users] Layer
rendering performance problem<BR></FONT><BR></DIV>
<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">mapserver-users-request@lists.osgeo.org</A>
wrote:</DIV><BR class=Apple-interchange-newline>
<BLOCKQUOTE type="cite"><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; 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"
class=Apple-style-span>
<DIV style="MARGIN: 0px"><SPAN
style="FONT-FAMILY: Helvetica; COLOR: rgb(127,127,127); FONT-SIZE: medium"><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: 0px"><SPAN
style="FONT-FAMILY: Helvetica; COLOR: rgb(127,127,127); FONT-SIZE: medium"><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: 0px"><SPAN
style="FONT-FAMILY: Helvetica; COLOR: rgb(127,127,127); FONT-SIZE: medium"><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: 0px"><SPAN
style="FONT-FAMILY: Helvetica; COLOR: rgb(127,127,127); FONT-SIZE: medium"><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></BLOCKQUOTE></BODY></HTML>