length of filter

Stefano B. stefano.bonnin at COMAI.TO
Thu Nov 10 01:07:10 PST 2005


> in my application the filter can have up to 2000 differnet "ids" and
> therefore 2000 "or" statements. (like "id='XXXXX' or")
> with up to 400 "ids" it works perfect, but if I want more "ids" in the
> FILTER the mapserver crashes.
> if I execute the sql in postgres (select the_geom from gd_poly_003 where
> (id='41216' or id='40445' ....)) it works even with 2000 "or" statements.

2000 or statements? incredible query! :-)

I'm not sure, but perhaps you could rewrite the query in another way.
Like:

DATA "the_geom from (select the_geom from gd_poly_003 where id IN (select id
from gd_poly_003 where <WHERE CONDITION>))"

or something like that.

Stefano



More information about the MapServer-users mailing list