[Chameleon] Problems with query on postgis layer

[Jeremy Palmer]

Hi everyone,

Two questions:

1)  I have a postgis polygon layer that is taking a long time query using
the query widget. Layers in ESRI shape files seem very quick, however but
the postgis layer takes a couple of minutes to return an answer.

Here is my layer, it maps correctly:

LAYER
  NAME "parcels"
  CONNECTIONTYPE postgis
  CONNECTION "user=postgres password=xxxx dbname=xxx host=localhost"
  DATA "shape from parcel"
  STATUS DEFAULT
  TYPE POLYGON
  DUMP true
  template "blank.html"
  MAXSCALE 20000
  
  CLASS
    EXPRESSION ('[status]' eq 'CURR' and '[toc_code]' eq 'PRIM' and
'[parcel_intent]' ne 'ROAD' and   '[parcel_intent]' ne 'HYDR' )
    NAME "CURR Parcels"
    OUTLINECOLOR 0 0 0
  END
  
  CLASS
    EXPRESSION ('[status]' eq 'CURR' and '[toc_code]' eq 'PRIM' and
'[parcel_intent]' eq 'ROAD')
    NAME "CURR Road Parcels"
    OUTLINECOLOR 0 0 0
    COLOR 255 222 140
  END

  CLASS
    EXPRESSION ('[status]' eq 'CURR' and '[toc_code]' eq 'PRIM' and
'[parcel_intent]' eq 'HYDR')
    NAME "CURR Hydro Parcels"
    OUTLINECOLOR 0 0 0
    COLOR 161 189 234
  END
END

2)  When items are queried using the query widget is it possible to
highlight the point/polygon on the map for the user?

Thanks heaps