[fdo-users] PostGIS FDO Provider performance issues

Zac Spitzer zac.spitzer at gmail.com
Wed Jun 11 03:02:42 EDT 2008

I would agree it's too much overhead, as this happening with Oracle as
well ( anyone else seen
this happen with another db?) perhaps there is something else in play.

How many rows are fetched by the client? Fetching one row at a time is
slower than returning blocks of 100 rows..

Using mapguide, it's always the mapguide process (ie FDO) and not the
database which is showing the high cpu


On Wed, Jun 11, 2008 at 4:56 PM, Carl Jokl <carl.jokl at keynetix.com> wrote:
> It is true that there is extra overhead in performing the conversion or going
> through FDO but I think it is fair to say that having PostGIS 16 to 20 times
> slower on the same data is more of a performance hit than would have been
> expected.
> --
> View this message in context: http://www.nabble.com/PostGIS-FDO-Provider-performance-issues-tp17756475p17771210.html
> Sent from the FDO Users mailing list archive at Nabble.com.
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users

Zac Spitzer -
http://zacster.blogspot.com (My Blog)
+61 405 847 168

More information about the fdo-users mailing list