length of filter
Gernot Katzlberger
knozi at GMX.AT
Thu Nov 10 00:35:36 PST 2005
hi list,
i have an mapfile with these parameters (mapserver-version 4.4.0).
DATA "the_geom from gd_poly_003"
FILTER (id='41216' or id='40445' or id='60101' or id='60411' or id='61022'
or id='61713' or id='60614' or id='60644' or id='61513' or id='61023' or
id='60622' or id='60608' or id='60611' or id='60504' or id='61045' or
id='60617' or id='61018' or id='60619' or id='61005' or id='60629' or
id='61511' or id='61047' or id='60655' or id='60624' or id='60633' or
id='60323' or id='60609' or id='61002' or id='61021' or id='60635')
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.
is there a limitation of the length of the FILTER in mapserver?
thanks for your help,
gernot
More information about the MapServer-users
mailing list