ITEMNQUERY - speed / thoughts

[Mike Saunt]

Hi All

I've got a requirement to be able to 'select' multiple features and then
perform a query against them to find features from other layers that
intersect.  The goal is for an interactive tool to select polygons which
will be highlighted on every map redraw (using itemnquery) and when the user
chooses to have a feature query (itemfeaturequery) against them all.

Our issue is that our selectable layer could have in excess of 1.5 million
features and the speed for each map refresh / feature qwould be too long.
We're testing agaisnt MapInfo TAB but can have the layer in Shape or
PostGIS.

Questions therefore are:
Can we have an attribute index built against the field for the layer somehow
that MapServer can read and therefore become ALOT faster?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080130/19df4cdb/attachment.htm>