Hi Zac, I thing you are not right about way provider is working. Provider is not using arbitrary schema and optimization is possible and it uses oracle schemas which are accessible to that user.
Provider will access tables which are accessible to that Oracle User. One way to optimize is to have Oracle User which will have access to tables of interest for application , instead of all tables. It is not new caching that will help, but in FDO it wil be possible to ask provider about particullar class instead of all classes. In some cases that can make difference. Just for reading static spatial data, files will be faster than db but many other functionalities will be missing. Haris -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zac Spitzer Sent: Saturday, October 04, 2008 2:47 PM To: MapGuide Users Mail List Subject: Re: [mapguide-users] Please help! Has anybody used King.Oracle inreal conditions? caching is in the next release, unfortunately, the king oracle provider will enumerate all accessible spatial content in the database via all tables which requires a permissions check over and over again. which is really slow. If your a dba user, the dba_ views would be much faster http://zacster.blogspot.com/2008/08/mapguide-fdo-making-oracle-describe. html Because the provider uses an arbitrary schema rather than on per oracle user, as most people would expect, optimizations like using the user_ views is not possible As a result the describe schema sucks..... I spent a while trying to advocate changing this owner on the fdo list, but it didn;t go anywhere I had a good discussion with Geoff Zeiss a few weeks ago at an Autodesk conference in the hunter valley about his stuff.. The new caching will help, but it's a band aid over a fundamental design problem with the way the provider access the database. FDO providers aren't transparent either, each one does it differently http://zacster.blogspot.com/2008/08/some-ponderings-on-fdo-schemas.html http://geospatial.blogs.com/geospatial/2008/09/proposal-for-si.html As for general performance with oracle, your going to be waaaay better off exporting out to SDF or SQLlite than accessing it from oracle... z On Sat, Oct 4, 2008 at 3:38 AM, gingerbbm <[EMAIL PROTECTED]> wrote: > > I am facing the same problems. MapGuide Open Source running on Windows Server > 2003 and IIS6, using King.Oracle to connect to an Oracle 10g database. > > Everything's working pretty well except for the fact the memory gets gobbled > at an alarming rate, and it doesn't ever seem to be freed. > > As an aside, I'm concerned about the performance of the enumeration of > spatial objects in the database. It appears that this happens once per > database schema. Is there some way of making this quicker? Or caching the > information before users hit the site? I'd appreciate any advice because > although it's close, it's not good enough to go live with. And I've invested > a lot of time in this product which I'd like to see the benefit of :) > > Any help is greatly appreciated. > > Cheers > Stuart > -- > View this message in context: http://n2.nabble.com/Please-help%21-Has-anybody-used-King.Oracle-in-real -conditions--tp1140937p1142504.html > Sent from the MapGuide Users mailing list archive at Nabble.com. > > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > -- Zac Spitzer - http://zacster.blogspot.com (My Blog) +61 405 847 168 _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
