[mapguide-users] Please help! Has anybody used King.Oracle in
zac.spitzer at gmail.com
Sat Oct 4 08:46:32 EDT 2008
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
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
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
As for general performance with oracle, your going to be waaaay better
off exporting out to
SDF or SQLlite than accessing it from oracle...
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.
> 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
Zac Spitzer -
http://zacster.blogspot.com (My Blog)
+61 405 847 168
More information about the mapguide-users