[mapserver-users] MapServer consuming 100% CPU

[Desarrollo Desarrollo]

Thank you very much for your answer,

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
(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!
Will MySQL spatial data increase the speed and number of features that
MapServer can manage?

Best regards


2008/2/21, Bart van den Eijnden (OSGIS) <bartvde at osgis.nl>:
>
> It is because Mapserver cannot use any attribute indexes on the DBF.
>
> Put your shapefile in a spatial database like PostGIS I would suggest and
> create attribute indexes.
>
> Best regards,
> Bart
>
> --
> Bart van den Eijnden
> OSGIS, Open Source GIS
> http://www.osgis.nl
>
>
> --------- Oorspronkelijk bericht --------
> Van: Paul Spencer <pspencer at dmsolutions.ca>
> Naar: Desarrollo Desarrollo <devmapserver at gmail.com>
> Cc: mapserver-users at lists.osgeo.org
> Onderwerp: Re: [mapserver-users] MapServer consuming 100% CPU
> Datum: 21/02/08 11:09
>
>
> > See:
> >
> > http://mapserver.gis.umn.edu/docs/howto/mapfiletuning
> > http://mapserver.gis.umn.edu/docs/howto/optimizevector
> > http://mapserver.gis.umn.edu/docs/howto/tileindex
> >
> > Cheers
> >
> > Paul
> >
> > On 21-Feb-08, at 2:56 AM, Desarrollo Desarrollo wrote:
> >
>
> > &gt; Hi,
> > &gt;
> > &gt;    I am developing an application with  MapServer v2.2.7 with
> > &gt; Apache  on Windows XP, but I have a serious problem, below I
> > &gt; describe it:
> > &gt;
> > &gt; Using Navteq demo maps from Paris, the Streets.shp have around
> > &gt; 500000 line strings features, when mapserver renders the layer
> > &gt; without using DBF data (only  draw lines) everything is OK and
> fast,
>
> > &gt; but when mapserver needs to access to the DBF to render labels or
> > &gt; use expressions to filter data, mapserver starts to consuming 100%
> > &gt; CPU and nothing is rendered after to spends a long time.
> > &gt;
> > &gt; Using Teleatlas demo maps for a medium city of Spain, the
> Street.shp
>
> > &gt; with around 11000 line strings features doesn't show any trouble
> and
>
> > &gt; mapserver  renders the images OK and fast even accessing to DBF to
> > &gt; render labels
> > &gt;
> > &gt; Could somebody help me with this problem? Why does it happen? How
> do
>
> > &gt; I solve it?
> > &gt;
> > &gt;
> > &gt; Thank you very much.
> > &gt; _______________________________________________
> > &gt; mapserver-users mailing list
> > &gt; mapserver-users at lists.osgeo.org
> > &gt; http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
> >
> >
> > __________________________________________
> >
> >     Paul Spencer
> >     Chief Technology Officer
> >     DM Solutions Group Inc
> >     http://www.dmsolutions.ca/
> >
> > _______________________________________________
> > mapserver-users mailing list
> > mapserver-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapserver-users
> >
> >
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080222/e23462d5/attachment-0001.html