[mapserver-users] Re: Inefficient rendering of layer

[Lime, Steve D (DNR)]

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 at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of juliap
Sent: Tuesday, March 27, 2012 12:50 PM
To: mapserver-users at 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 at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users