[fdo-users] Basic FDO questions.

[Zac Spitzer]

On Sat, Mar 15, 2008 at 6:25 PM, ssakharov <ssakharov at gmail.com> wrote:
>
>
>  Yeah, shp files give excellent performance.
>  Do you know if there is any significant performance difference when talking
>  to oracle spatial direct, vs via fdo?

yep, oracle via FDO is still pretty much unusable performance wise

doing the same thing directly via jdbc is a factor of 10 times faster,
not to mention
the cpu load... it's not ready for production, IMHO, due to the CPU load

it looks to me like there's some heavy conversion going on inside the provider

based on some playing around last week, it might even be faster to
read directly,
write to SDF via FDO and then query/render than going straight via FDO

using 3.3.0 ( not the release version, the ftp one from sl-king, as
there is a DWMAPI.DLL
issue in the download of osegeo http://trac.osgeo.org/fdo/ticket/274 )
it took like 10
seconds to read 2,500 records in using a feature reader

>
>
>
>
>
>  zspitzer wrote:
>  >
>  > In regards to 4) performance wise the king.oracle provider is pretty
>  > man slow and CPU heavy
>  > if you compare it to the same data coming out of a SHP/SDF file
>  >
>  > On Sat, Mar 15, 2008 at 5:01 PM, ssakharov <ssakharov at gmail.com> wrote:
>  >>
>  >>
>  >>  Hey all,
>  >>
>  >>  I am in the process of evaluating FDO for my gis application.  I am
>  >> stuck
>  >>  with C#, so thankfully FDO has Managed bindings.  So far I have been
>  >> playing
>  >>  with the WMS provider, and mostly with success.  But i cant seem to find
>  >>  answer for some questions, hopefully you guys can help me out here.
>  >> Most of
>  >>  my questions revolve around the WMS provider as its the only one I ve
>  >> played
>  >>  with so far.
>  >>
>  >>  1) Can i get access to all the layers meta properties, so far using the
>  >> jpl
>  >>  and metacarta WMS servers i can only seem to ever get 2 properties, i)
>  >> the
>  >>  id, and ii) the raster property.  Is this just cause the WMS servers I
>  >> am
>  >>  hitting don't provide any more properties?  Also the abstract that most
>  >> WMS
>  >>  servers provide?
>  >>
>  >>  2) The WMS provider seems to support reprojecting, (through the override
>  >>  raster definition, but i havent tested this yet) I imagine this is cause
>  >> WMS
>  >>  in general support reprojecting, do the other providers support this?
>  >>
>  >>  3) I dont understand the abstract feature i get in the WMS schema's,
>  >> this is
>  >>  probably just my stupidity.
>  >>
>  >>  4) Is there a significant performance hit in general using FDO.
>  >>
>  >>  5) Has anyone written more tutorial info for FDO, i find my self looking
>  >> to
>  >>  the unit tests for info.
>  >>
>  >>  6) Do any of the spatial db providers, provide support for rasters in
>  >> the
>  >>  db, or just geometry?
>  >>
>  >>
>  >>
>  >>
>  >>
>  >>  --
>  >>  View this message in context:
>  >> http://www.nabble.com/Basic-FDO-questions.-tp16064455s18162p16064455.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
>  > _______________________________________________
>  > fdo-users mailing list
>  > fdo-users at lists.osgeo.org
>  > http://lists.osgeo.org/mailman/listinfo/fdo-users
>  >
>  >
>
>  --
>  View this message in context: http://www.nabble.com/Basic-FDO-questions.-tp16064455s18162p16065363.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