Expression so slow ...

[Paul james]

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 <pauljame at GMAIL.COM>
*To:* MAPSERVER-USERS at LISTS.UMN.EDU
*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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20061208/e7257274/attachment.htm>