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