[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mapserver-users
Subject:    RE: [mapserver-users] Re: Inefficient rendering of layer
From:       "Lime, Steve D (DNR)" <Steve.Lime () state ! mn ! us>
Date:       2012-03-27 18:26:11
Message-ID: C549F0496453D842B4DD71AC8188DDC510309A () 055-CH1MPN1-043 ! 055d ! mgd ! msft ! net
[Download RAW message or body]

You have to tune your SQL in this case. There are other minor speedups in MapServer
to be had, for example, use CLASSITEM and simple expressions.

CLASSITEM 'PartyVotingFor'
CLASS
  EXPRESSION '1'
  ...
END
CLASS
  EXPRESSION '2'
  ...
END
CLASS
  EXPRESSION '3'
  ...
END
CLASS # use last one as a default
  ...
END

You also can order the classes based on anticipated frequency, but again these are 
minor compared to what you can gain with SQL tuning.

Steve

-----Original Message-----
From: mapserver-users-bounces@lists.osgeo.org \
                [mailto:mapserver-users-bounces@lists.osgeo.org] On Behalf Of juliap
Sent: Tuesday, March 27, 2012 12:50 PM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] Re: Inefficient rendering of layer

I am not an SQL expert .  Do you know any other alternative?

--
View this message in context: \
http://osgeo-org.1560.n6.nabble.com/Inefficient-rendering-of-layer-tp4661670p4661757.html
 Sent from the Mapserver - User mailing list archive at Nabble.com.
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


[prev in list] [next in list] [prev in thread] [next in thread]