[fdo-users] King Oracle join performance

[Zac Spitzer]

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 :)

z





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
http://www.ennoble.com.au
http://zacster.blogspot.com
+61 405 847 168