[fdo-users] Another FDO PostGIS Selection Problem
ary.sucaya at yahoo.com
Mon Mar 17 15:07:07 EDT 2008
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
----- 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
Also, don't forget to:
- generated GiST index
- run VACCUM and ANALYZE
see 4.5.1. section in the PostGIS manual
fdo-users mailing list
fdo-users at lists.osgeo.org
Never miss a thing. Make Yahoo your home page.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the fdo-users