FILTER slow

[Stephan Holl]

Hallo mapserver-users,

I have a problem using the FILTER inside a shape-layer. It turns out
that the filters are getting quite slow when using more than ~500
or-validations.

The filter gets applied by mapscript based on an
external-database query-result. Are there some tuning-tipps how to
'filter' (shape)-datasets with large results efficient?

Currently the filter looks like this
 LAYER
    DATA "adr"
      FILTER ( [adr_id] = 6446 OR [adr_id] = 6366 OR [adr_id] = 6483 OR
[adr_id] = 6534 OR [adr_id] = 6535 OR [adr_id] = 6481 OR [adr_id] =
6489 OR [adr_id] = 6490 OR [adr_id] = 6478 OR [adr_id] = 6587 OR
[adr_id] = 6484 OR [adr_id]
[many more follow]
FILTERITEM "adr_id"
      METADATA
        "DESCRIPTION"   "Abfrageebene f<FC>r abfrageergebnisse"
        "SKIP_LEGEND"   "3"
      END
    NAME "blanko"
    SIZEUNITS PIXELS
    STATUS OFF
    TOLERANCEUNITS PIXELS
    TYPE POINT
    UNITS METERS
 [CLASS ommitted]
END


Thank you for any pointers.

Best regards

	Stephan