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