[fdo-users] Another FDO PostGIS Selection Problem

Jason Birch Jason.Birch at nanaimo.ca
Mon Mar 17 16:03:43 EDT 2008

I think that Mateusz is suggesting the following:

- Turn on statement logging for PostgreSQL:

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

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?


More information about the fdo-users mailing list