[Chameleon] Problems with query on postgis layer

[Paul Spencer]

Jerry,

we fixed our problem by building GIST and BTREE indexes on the database, 
the code in chameleon and mapserver seems to be reasonably optimal (i.e. 
it doesn't repeat things too many times).  I still have some doubts 
about feature caching by postgis but that doesn't seem to have much 
effect in my examples ...

Cheers,

Paul

Paul Spencer wrote:

> 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/|
  -----------------------------------------------------------------