[mapguide-users] Another Selection Problem

[ary sucaya]

Can you tell me how to turn on tracing? 


Regards,

Ary Sucaya


----- Original Message ----
From: Dave Wilson <dave.wilson at autodesk.com>
To: MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
Sent: Monday, March 17, 2008 5:18:51 PM
Subject: RE: [mapguide-users] Another Selection Problem


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.


-----Inline Attachment Follows-----

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080317/220af2a4/attachment.html