[mapguide-users] Please help! Has anybody used King.Oracle in real conditions?

[Zac Spitzer]

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 <stuart.jones at jacobs.com> 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
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



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