[mapguide-users] King.Oracle 0.3.3
Jason Birch
Jason.Birch at nanaimo.ca
Wed Oct 25 11:15:49 EDT 2006
Same opinion, and in most cases the difference between Oracle and SDF
was not large enough to require a filesystem data source (unless you had
other reasons, like not wanting to fall into the megabuck
Enterprise+Spatial trap)
I'd expect the same results with MGOS, but with one exception. SDF+
only appears to support indices on one "identity" column, but it allows
you to store your full attribution. If you are doing any kind of
attribute query against other columns, I believe that a properly indexed
Oracle source will have a huge performance advantage.
Jason
________________________________
From: Andy Morsell [mailto:amorsell at spatialgis.com]
Sent: Tuesday, October 24, 2006 20:55
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] King.Oracle 0.3.3
I agree that with MapGuide 6.5, Oracle Spatial is nearly as fast as SDF.
Nothing beats SDF, however. It's hard to say with the current versions
of MGOS and the King provider since I doubt that anyone has bench marked
it against SDF+ to date, but I would ultimately expect similar
performance. The same goes for the Autodesk Oracle Spatial FDO
provider: I expect that the improvements that Autodesk are making to it
will bring it more back in line with performance of MapGuide 6.5. I saw
a beta version of the patched provider about a month ago, and my tests
indicated that it will be much, much better than the current version.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20061025/227ee74c/attachment.html
More information about the Mapguide-users
mailing list