[fdo-users] Another FDO PostGIS Selection Problem

[ary sucaya]

I haven't check MySql provider, but i did on SDF provider with no problems. I notice that this problem occurs when i tried to deselect feature on big scale view. On scale 1:24498498 deselect process is quick, but on scale 1:2955 deselect process very poor. Same feature has different behaviour on different scale.
Yes i ran vacuum and create gist index but still no lucky

Regards,


Ary Sucaya


----- Original Message ----
From: Mateusz Loskot <mateusz at loskot.net>
To: FDO Users Mail List <fdo-users at lists.osgeo.org>
Sent: Monday, March 17, 2008 7:45:51 PM
Subject: Re: [fdo-users] Another FDO PostGIS Selection Problem

ary sucaya wrote:
> Hii all,
> 
> I have another selection problem on PostGIS FDO with MapGuide OS. 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? I make use
> of FDO 3.3 and MapGuide OS 2.0

Have you checked if similar problem occurs with ie. MySQL provider?
It's important to identify on which side is the problem: the provider,
FDO framework or MapGuide.

I'd suggest to enable SQL statements logging for PostgreSQL, walk again 
through all problematic interactions and check what SQL statements are 
executed. Next, I'd execute every statement manually, in psql or pgAdmin
and observe performance.

This should give rough answer if the problem is PostGIS provider fault 
or not.

Also, don't forget to:
- generated GiST index
- run VACCUM and ANALYZE

see 4.5.1. section in the PostGIS manual
http://postgis.refractions.net/docs/ch04.html

Greetings
-- 
Mateusz Loskot
http://mateusz.loskot.net
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users


      ____________________________________________________________________________________
Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20080317/49b444cb/attachment.html