[Chameleon] Problems with query on postgis layer

[Paul Spencer]

Interesting that you bring this up now :)  We've got the same problem in 
one of our client's apps.  We will be investigating and hopefully fixing 
the problem this week.  The problem may be in either the chameleon code 
or in how mapserver passes queries to the postgis engine, not sure 
exactly where it is.

I'll let the list know when we find the problem.

Cheers,

Paul

Jeremy Palmer wrote:
> 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
> 
> 
> _______________________________________________
> Chameleon mailing list
> Chameleon at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/chameleon
> 

-- 
  -----------------------------------------------------------------
|Paul Spencer                           pspencer at dmsolutions.ca   |
|-----------------------------------------------------------------|
|Applications & Software Development                              |
|DM Solutions Group Inc                 http://www.dmsolutions.ca/|
  -----------------------------------------------------------------