[mapguide-users] Another Selection Problem

[Dave Wilson]

Tracing can probably be turned on using tools from the database server itself. I'm not aware of tracing available via the provider.

Dave

From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of ary sucaya
Sent: Monday, March 17, 2008 10:35 AM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] Another Selection Problem

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.<http://us.rd.yahoo.com/evt=51734/*http:/tools.search.yahoo.com/newsearch/category.php?category=shopping>


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

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


________________________________
Never miss a thing. Make Yahoo your homepage.<http://us.rd.yahoo.com/evt=51438/*http:/www.yahoo.com/r/hs>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080317/136d1f26/attachment.html