[Chameleon] query performance and weird behavior

[Eijnden, B. van den (Bart)]

Do they all have indexes on the oid field?

Also, what is your DATA statement in the MAP file? Does it use "USING
UNIQUE" or not? If so, is the UNIQUE column also indexed?

You could also turn PostgreSQL logging on, see which queries Mapserver runs
against PostGIS, and see how fast they run in the database.

Best regards,
Bart

-----Oorspronkelijk bericht-----
Van: chameleon-bounces at lists.maptools.org
[mailto:chameleon-bounces at lists.maptools.org]Namens Danna Dowdy
Verzonden: woensdag 4 januari 2006 22:15
Aan: chameleon at lists.maptools.org
Onderwerp: [Chameleon] query performance and weird behavior


I am running into a couple of problems and I really hope someone can 
help me....
Currently, I have three different postgis layers which are coming from 
views.  Two of them work fine, but one layer in particular just runs and 
runs and finally returns an empty page for query results?  Anyone ever 
experience this before? 
Also, I was wondering if anyone could point me in the right direction 
for some performance tuning for query results...
I am returning alot of results depending on the active layers chosen, 
but sometimes it takes several minutes?
_______________________________________________
Chameleon mailing list
Chameleon at lists.maptools.org
http://lists.maptools.org/mailman/listinfo/chameleon


Disclaimer
************************************************************************
Aan dit bericht kunnen geen rechten worden ontleend. Dit bericht is
uitsluitend bestemd voor de geadresseerde. Als u dit bericht per abuis
hebt ontvangen, wordt u verzocht het te vernietigen en de afzender te 
informeren. Wij adviseren u om bij twijfel over de juistheid of de 
volledigheid van de mail contact met afzender op te nemen.

This message shall not constitute any rights or obligations.
This message is intended solely for the addressee.
If you have received this message in error, please delete it and
notify the sender immediately. When in doubt whether this message
is correct or complete, please contact the sender.
************************************************************************