[Chameleon] Problems with query on postgis layer

[Jeremy Palmer]

Thanks, The creation of the index of the oid worked! 

It's a bit of pity about the second question. Oh well maybe the
functionality will happen in the future.

Much appreciated 

Jeremy

-----Original Message-----
From: Bart van den Eijnden [mailto:bartvde at xs4all.nl] 
Sent: Wednesday, 2 June 2004 10:10 a.m.
To: spencer at dmsolutions.ca; Jeremy Palmer
Cc: chameleon at lists.maptools.org
Subject: Re: [Chameleon] Problems with query on postgis layer

Hi,

Just checking, did you create an index on the oid field? That solved my 
problem, although I was experiencing a slow performance of 5 seconds 
instead of minutes :)

create index top50_oid_idx on table (oid);

With regard to your second question Jeremy, it is possible in theory, but 
not out of the box in Chameleon. This means an SLD (+ Filter) GetMap 
request would also have to be generated which would highlight the selected 
(clicked) feature.

Best regards,
Bart

On Sun, 30 May 2004 10:07:11 -0400, Paul Spencer <pagameba at magma.ca> 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
>>
>



--