Hello again... The problem is not the expressions ... I took off them and the problem continue ....
I believe is a problem with my sql : _layer.data = "the_geom from (select count(def.descproblem) as number, def.descproblem, tg.city, lm.geocode, lm.the_geom from tblTower tg inner join tblInsp on (tg.numgeraltower = i2.numgeraltower and tg.idlt = i2.idlt) inner join tblProblens def on ( i2.idproblem = def.idproblem and i2.idlt = def.idlt) inner join limit_city lm on (upper(lm.name) = upper(tg.city) and upper( lm.uf) = upper(tg.estate)) where def.descproblem = 'PROBLEM DETECTED' and i2.datemanutencao BETWEEN '2005-01-01' AND '2006-11-30' group by def.descproblem, tg.city, lm.geocode, lm.the_geom order by number) as thematic using unique geocode using srid=-1"; Any idea? ----- Original Message ----- *From:* Paul james <[EMAIL PROTECTED]> *To:* [email protected] *Sent:* Thursday, December 07, 2006 4:21 PM *Subject:* [UMN_MAPSERVER-USERS] Expression so slow ... Hello guys! I´m creating a POLYGON layer in mapscript (c#) with a lot of classes like that : layerObj _layer = new layerObj(mapaObj); _layer.classitem = "geocode"; .... while (_reader.Read()) { _geo = Convert.ToInt32(_reader["geocode"]); _city = _reader["city"].ToString(); classObj _class = new classObj(_layer); _class.name = __city; _class.template = "dummy"; _class.setExpression(_geo.ToString()); styleObj _style = new styleObj(_class); _style.color.setRGB(_num.Next(0, 255), _num.Next(0, 255), _num.Next(0, 255)); } All works great, so I got a Themathic map (very fast - about 2secs) The problem occurs when I started to aproximate to one new POLYGON (Zoomin). Each zoom took more and more time (about 8-10secs) to draw the map. Its very strange... Did I miss anything? ps.: I´m using Mapserver 4.10, windows xp and C# []´s
