<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">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.</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">Yes i ran vacuum and create gist index but still no lucky</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">Regards,</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">Ary Sucaya<BR><BR></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Original Message ----<BR>From: Mateusz Loskot <mateusz@loskot.net><BR>To: FDO Users Mail List <fdo-users@lists.osgeo.org><BR>Sent: Monday, March 17, 2008 7:45:51 PM<BR>Subject: Re: [fdo-users] Another FDO PostGIS Selection Problem<BR><BR>ary sucaya wrote:<BR>> Hii all,<BR>> <BR>> I have another selection problem on PostGIS FDO with MapGuide OS. I<BR>> attach a small bitmap to describe my problem. Referring to that<BR>> attachement, i have 2 rectangle of 500 m x 500 m. If I do a click<BR>> outside the rectangle (red dot), MapGuide OS response is very very<BR>> slow. It takes around 5 minute until refreshed. If accidently I do<BR>> another click, my browser will hang. From my observation, it look<BR>> like a heavy process took place. Mgserver use 98,781 K of memory<BR>> during that process and decrease into 65,444 K when the
process<BR>> finnish. The area inside rectangle (green dot) is fine, the response<BR>> quick enough. Is there a way to speed up deselect process? I make use<BR>> of FDO 3.3 and MapGuide OS 2.0<BR><BR>Have you checked if similar problem occurs with ie. MySQL provider?<BR>It's important to identify on which side is the problem: the provider,<BR>FDO framework or MapGuide.<BR><BR>I'd suggest to enable SQL statements logging for PostgreSQL, walk again <BR>through all problematic interactions and check what SQL statements are <BR>executed. Next, I'd execute every statement manually, in psql or pgAdmin<BR>and observe performance.<BR><BR>This should give rough answer if the problem is PostGIS provider fault <BR>or not.<BR><BR>Also, don't forget to:<BR>- generated GiST index<BR>- run VACCUM and ANALYZE<BR><BR>see 4.5.1. section in the PostGIS manual<BR><A href="http://postgis.refractions.net/docs/ch04.html"
target=_blank>http://postgis.refractions.net/docs/ch04.html</A><BR><BR>Greetings<BR>-- <BR>Mateusz Loskot<BR><A href="http://mateusz.loskot.net/" target=_blank>http://mateusz.loskot.net</A><BR>_______________________________________________<BR>fdo-users mailing list<BR><A href="mailto:fdo-users@lists.osgeo.org" ymailto="mailto:fdo-users@lists.osgeo.org">fdo-users@lists.osgeo.org</A><BR><A href="http://lists.osgeo.org/mailman/listinfo/fdo-users" target=_blank>http://lists.osgeo.org/mailman/listinfo/fdo-users</A><BR></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR></DIV></div><br>
<hr size=1>Looking for last minute shopping deals? <a href="http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping">
Find them fast with Yahoo! Search.</a></body></html>