[fdo-users] King Oracle join performance

Zac Spitzer zac.spitzer at gmail.com
Thu May 13 22:07:06 EDT 2010

you can just create the view and then add the required user_geom_metadata
for the view and it should show up without the KingFdoClass stuff.

doing it inside the database is really efficent, joins between FDO
provider inside
mapguide is like moving house with a mini cooper :)


On 14 May 2010 08:12, Jason Birch <jason at jasonbirch.com> wrote:
> You can use the KingFdoClass table to do this (it doesn't support xml
> configuration-based class definitions)
> http://www.sl-king.com/fdooracle/KingFdoClass.htm
> Jason
> On 13 May 2010 11:50, Romica Dascalescu wrote:
>> I think MGOS it has an internal module for joins and is not using Oracle
>> join. So I think server is getting all data and is doing 'client' side
>> joins.
>> I think there is a way to avoid that (but I'm not sure King provider
>> supports that), is to create a view based on your join and expose that view
>> as a feature class. This way your view will be like a read-only class.
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users

Zac Spitzer
Solution Architect / Director
Ennoble Consultancy Australia
+61 405 847 168

More information about the fdo-users mailing list