[fdo-users] King Oracle join performance

[Romica Dascalescu]

Hi Ben,

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.

Regards,
Romy.
________________________________________
From: fdo-users-bounces at lists.osgeo.org [fdo-users-bounces at lists.osgeo.org] On Behalf Of Ben Mor [ptolemyx at shaw.ca]
Sent: Thursday, May 13, 2010 2:28 PM
To: fdo-users at lists.osgeo.org
Subject: [fdo-users] King Oracle join performance

When displaying data from a main SDE feature class table with about 1 million
entries, the King Oracle provider is very fast.

I need to filter the entries for security purposes. I have a secondary
non-SDE table that contains IDs from the main table that are available to
public users (about 900k entries). Joining this table to the main table in
an Oracle query (using SQL Developer) is just as fast as querying the main
table directly.

I've added the security table to the KingFdoClass table so that I can create
the same join in MGOS. When I try to view the resulting class in my map, the
viewer doesn't return -- it simply hangs while waiting for features from the
server.

How can I debug this problem?


--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/King-Oracle-join-performance-tp5047462p5047462.html
Sent from the FDO Users mailing list archive at Nabble.com.
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users