<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><P>Well, I turn on postgres logging. I found there are 6 query during deselect process:</P>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><FONT color=#e6e6e6>SELECT "public"."fotoudara".batas,"public"."fotoudara".lembar,"public"."fotoudara".tahun,"public"."fotoudara".akurasi,"public"."fotoudara".proyeksi,"public"."fotoudara".format,"public"."fotoudara".sumber,"public"."fotoudara".pemilik,"public"."fotoudara".kontak,"public"."fotoudara".catatan FROM "public"."fotoudara" WHERE ( ( lembar LIKE '50.1%' ) AND ( batas && GeomFromWKB(decode('01030000000100000005000000AB3AB267A57D5C404EBC847AC10226C0CFA7527EA67D5C404DBC847AC10226C0CFA7527EA67D5C407225882FCA0226C0AB3AB267A57D5C407225882FCA0226C0AB3AB267A57D5C404EBC847AC10226C0', 'hex'),4326) AND Intersects(batas,GeomFromWKB(decode('01030000000100000005000000AB3AB267A57D5C404EBC847AC10226C0CFA7527EA67D5C404DBC847AC10226C0CFA7527EA67D5C407225882FCA0226C0AB3AB267A57D5C407225882FCA0226C0AB3AB267A57D5C404EBC847AC10226C0', 'hex'),4326)) )
);</FONT><BR><FONT color=#ff0000>SELECT "public"."fotoudara".batas,"public"."fotoudara".lembar,"public"."fotoudara".tahun,"public"."fotoudara".akurasi,"public"."fotoudara".proyeksi,"public"."fotoudara".format,"public"."fotoudara".sumber,"public"."fotoudara".pemilik,"public"."fotoudara".kontak,"public"."fotoudara".catatan </FONT><FONT color=#ff0000>FROM "public"."fotoudara"<BR></FONT><FONT color=#d0d0d0>SELECT "public"."kecamatan".batas,"public"."kecamatan".gid,"public"."kecamatan".kode,"public"."kecamatan".nama,"public"."kecamatan".hm,"public"."kecamatan".hgb,"public"."kecamatan".hp,"public"."kecamatan".hw,"public"."kecamatan".fgid FROM "public"."kecamatan" WHERE ( batas && GeomFromWKB(decode('01030000000100000005000000AB3AB267A57D5C404EBC847AC10226C0CFA7527EA67D5C404DBC847AC10226C0CFA7527EA67D5C407225882FCA0226C0AB3AB267A57D5C407225882FCA0226C0AB3AB267A57D5C404EBC847AC10226C0', 'hex'),4326) AND
Intersects(batas,GeomFromWKB(decode('01030000000100000005000000AB3AB267A57D5C404EBC847AC10226C0CFA7527EA67D5C404DBC847AC10226C0CFA7527EA67D5C407225882FCA0226C0AB3AB267A57D5C407225882FCA0226C0AB3AB267A57D5C404EBC847AC10226C0', 'hex'),4326)) );</FONT><BR><FONT color=#ff0000>SELECT "public"."kecamatan".batas,"public"."kecamatan".gid,"public"."kecamatan".kode,"public"."kecamatan".nama,"public"."kecamatan".hm,"public"."kecamatan".hgb,"public"."kecamatan".hp,"public"."kecamatan".hw,"public"."kecamatan".fgid FROM "public"."kecamatan";</FONT><BR><FONT color=#d0d0d0>SELECT "public"."kecamatan".batas,"public"."kecamatan".gid,"public"."kecamatan".kode,"public"."kecamatan".nama,"public"."kecamatan".hm,"public"."kecamatan".hgb,"public"."kecamatan".hp,"public"."kecamatan".hw,"public"."kecamatan".fgid FROM "public"."kecamatan" WHERE ( batas &&
GeomFromWKB(decode('01030000000100000005000000D1C4E395577D5C4033EF6181D80626C09BF8A78A2E7E5C4033EF6181D80626C09BF8A78A2E7E5C408584CFCF310226C0D1C4E395577D5C408584CFCF310226C0D1C4E395577D5C4033EF6181D80626C0', 'hex'),4326) );<BR>SELECT "public"."fotoudara".batas,"public"."fotoudara".lembar,"public"."fotoudara".tahun,"public"."fotoudara".akurasi,"public"."fotoudara".proyeksi,"public"."fotoudara".format,"public"."fotoudara".sumber,"public"."fotoudara".pemilik,"public"."fotoudara".kontak,"public"."fotoudara".catatan FROM "public"."fotoudara" WHERE ( ( lembar LIKE '50.1%' ) AND ( batas && GeomFromWKB(decode('01030000000100000005000000D1C4E395577D5C4033EF6181D80626C09BF8A78A2E7E5C4033EF6181D80626C09BF8A78A2E7E5C408584CFCF310226C0D1C4E395577D5C408584CFCF310226C0D1C4E395577D5C4033EF6181D80626C0', 'hex'),4326) ) )</FONT></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">The reds sql above takes time, which are 609 ms (2803 rows) and 40704 ms (3994 rows) respectively. It looks like that sql make query for whole table. I couldn't understand why it makes query for whole tables. The other query limited by GeomFrom WKB and not takes time. By the time i did deselect, my map windows consists of two feature which are returned by 6rd sql above. <BR>Now my further question, if my database growing larger and larger, it will takes longer. Could you explain me?</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">BTW, i deselect feature by clicking on empty area, not by deselect toolbar</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">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">Ary Sucaya</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Original Message ----<BR>From: Jason Birch <Jason.Birch@nanaimo.ca><BR>To: FDO Users Mail List <fdo-users@lists.osgeo.org><BR>Sent: Monday, March 17, 2008 9:03:43 PM<BR>Subject: RE: [fdo-users] Another FDO PostGIS Selection Problem<BR><BR>I think that Mateusz is suggesting the following:<BR><BR>- Turn on statement logging for PostgreSQL:<BR><BR><A href="http://www.postgresql.org/docs/current/static/runtime-config-logging.htm" target=_blank>http://www.postgresql.org/docs/current/static/runtime-config-logging.htm</A><BR>l<BR><BR>- Perform the operation that is failing<BR><BR>- Retrieve the SQL text of the queries from the PostgreSQL logs<BR><BR>- Run the queries through the postgresql command line until you find the<BR>one with poor performance<BR><BR>- Run this through EXPLAIN to find out why it's so slow:<BR> <A
href="http://www.postgresql.org/docs/8.3/static/sql-explain.html" target=_blank>http://www.postgresql.org/docs/8.3/static/sql-explain.html</A> <BR><BR>Often, when this kind of performance problem happens it is because the<BR>initial indexed select query fails, and MapGuide falls back to an<BR>unconstrained query.<BR><BR>How are you clearing selection? Clicking on a place with no known<BR>features, or using a "clear select" button?<BR><BR>Jason<BR><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>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com </body></html>