[mapguide-users] Another Selection Problem

[Dave Wilson]

That almost seems like a query problem with the database. It sounds like it's doing a table scan which may be a sign of an index problem or bad SQL.

Is it possible to turn on tracing to see what queries are being sent to the database server?

Regards,
Dave

From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of ary sucaya
Sent: Sunday, March 16, 2008 4:55 AM
To: Mapguide User
Subject: [mapguide-users] Another Selection Problem

Hii all,

I have another selection problem on PostGIS FDO 3.3 with MapGuide OS 2.0. I attach a small bitmap to describe my problem. Referring to that attachement, i have 2 rectangle of 500 m x 500 m. If I do a click outside the rectangle (red dot), MapGuide OS response is very very slow. It takes around 5 minute until refreshed. If accidently I do another click, my browser will hang. From my observation, it look like a heavy process took place. Mgserver use 98,781 K of memory during that process and decrease into 65,444 K when the process finnish. The area inside rectangle (green dot) is fine, the response quick enough. Is there a way to speed up deselect process?


regards,

Ary Sucaya

________________________________
Looking for last minute shopping deals? Find them fast with Yahoo! Search.<http://us.rd.yahoo.com/evt=51734/*http:/tools.search.yahoo.com/newsearch/category.php?category=shopping>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080317/4eb63736/attachment.html