Thank you very much for your answer,<br><br>Therefore, Should I think that Shapefiles / DBF data is not suitable for MapServer if the number of features in the shapefile is a "big" number like 473815 line strings in the Streets.shp? I've tried with MajHwys.shp<br>
(35295 linestrings features) labeling and using expressions and works ok. Streets.shp with its 473815 linestrings is rendered fast if there is not DBF access (not labeling neither expressions), but when DBF access is needed Mapservers hangs up!<br>
Will MySQL spatial data increase the speed and number of features that MapServer can manage?<br><br>Best regards<br><br><br><div><span class="gmail_quote">2008/2/21, Bart van den Eijnden (OSGIS) <<a href="mailto:bartvde@osgis.nl">bartvde@osgis.nl</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
It is because Mapserver cannot use any attribute indexes on the DBF.<br> <br> Put your shapefile in a spatial database like PostGIS I would suggest and<br> create attribute indexes.<br> <br> Best regards,<br> Bart<br> <br>
--<br> Bart van den Eijnden<br> OSGIS, Open Source GIS<br> <a href="http://www.osgis.nl">http://www.osgis.nl</a><br> <br> <br> --------- Oorspronkelijk bericht --------<br> Van: Paul Spencer <<a href="mailto:pspencer@dmsolutions.ca">pspencer@dmsolutions.ca</a>><br>
Naar: Desarrollo Desarrollo <<a href="mailto:devmapserver@gmail.com">devmapserver@gmail.com</a>><br> Cc: <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br> Onderwerp: Re: [mapserver-users] MapServer consuming 100% CPU<br>
Datum: 21/02/08 11:09<br> <br><br> > See:<br> ><br> > <a href="http://mapserver.gis.umn.edu/docs/howto/mapfiletuning">http://mapserver.gis.umn.edu/docs/howto/mapfiletuning</a><br> > <a href="http://mapserver.gis.umn.edu/docs/howto/optimizevector">http://mapserver.gis.umn.edu/docs/howto/optimizevector</a><br>
> <a href="http://mapserver.gis.umn.edu/docs/howto/tileindex">http://mapserver.gis.umn.edu/docs/howto/tileindex</a><br> ><br> > Cheers<br> ><br> > Paul<br> ><br> > On 21-Feb-08, at 2:56 AM, Desarrollo Desarrollo wrote:<br>
><br> <br>> &gt; Hi,<br> > &gt;<br> > &gt; I am developing an application with MapServer v2.2.7 with<br> > &gt; Apache on Windows XP, but I have a serious problem, below I<br> > &gt; describe it:<br>
> &gt;<br> > &gt; Using Navteq demo maps from Paris, the Streets.shp have around<br> > &gt; 500000 line strings features, when mapserver renders the layer<br> > &gt; without using DBF data (only draw lines) everything is OK and fast,<br>
<br> > &gt; but when mapserver needs to access to the DBF to render labels or<br> > &gt; use expressions to filter data, mapserver starts to consuming 100%<br> > &gt; CPU and nothing is rendered after to spends a long time.<br>
> &gt;<br> > &gt; Using Teleatlas demo maps for a medium city of Spain, the Street.shp<br> <br> > &gt; with around 11000 line strings features doesn't show any trouble and<br> <br> > &gt; mapserver renders the images OK and fast even accessing to DBF to<br>
> &gt; render labels<br> > &gt;<br> > &gt; Could somebody help me with this problem? Why does it happen? How do<br> <br> > &gt; I solve it?<br> > &gt;<br> > &gt;<br> > &gt; Thank you very much.<br>
> &gt; _______________________________________________<br> > &gt; mapserver-users mailing list<br> > &gt; <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br> > &gt; <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
<br>><br> ><br> > __________________________________________<br> ><br> > Paul Spencer<br> > Chief Technology Officer<br> > DM Solutions Group Inc<br> > <a href="http://www.dmsolutions.ca/">http://www.dmsolutions.ca/</a><br>
><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">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
><br> ><br> <br> <br> <br> </blockquote></div><br>