[fdo-users] Another FDO PostGIS Selection Problem

[Jason Birch]

I think that Mateusz is suggesting the following:

- Turn on statement logging for PostgreSQL:
 
http://www.postgresql.org/docs/current/static/runtime-config-logging.htm
l

- Perform the operation that is failing

- Retrieve the SQL text of the queries from the PostgreSQL logs

- Run the queries through the postgresql command line until you find the
one with poor performance

- Run this through EXPLAIN to find out why it's so slow:
   http://www.postgresql.org/docs/8.3/static/sql-explain.html 

Often, when this kind of performance problem happens it is because the
initial indexed select query fails, and MapGuide falls back to an
unconstrained query.

How are you clearing selection?  Clicking on a place with no known
features, or using a "clear select" button?

Jason