[fdo-users] PostGIS FDO Provider performance issues

[Zac Spitzer]

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

z



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