have you added the spatial meta data for the view in Oracle <br>and then create both an index on the view and a PK? <br><br>It's required as it makes the views appear like normal spatial tables<br>for FDO... search the list archives as this has been explained before<br>
<br>I would recommend completely avoiding the feature joins and<br>stick to database views, it's far more efficient.<br><br>That said, this RFC for FDO 3.6 which IMS uses should really<br>improve the performance of feature joins as it generates a joined <br>
SQL query (for joins using the same connection) rather than multiple<br>requests, but alas mapguide doesn't support this yet<br><br><a href="http://trac.osgeo.org/fdo/wiki/FDORfc50">http://trac.osgeo.org/fdo/wiki/FDORfc50</a><br>
<br><br><br>z<br><br><div class="gmail_quote">On Thu, Oct 6, 2011 at 11:25 AM, tmblackflag <span dir="ltr"><<a href="mailto:steve.calpoly@gmail.com">steve.calpoly@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hello,<br>
<br>
I've found the join features are extremely limited in studio using the<br>
Autodesk FDO provider for Oracle. for this reason I've created a view that<br>
handles all my logic and then do a simple join from my feature source.<br>
<br>
Oddly, this works if I join to a physical table, but not to a join with the<br>
exact same columns and data types. Has anyone else experience this issue?<br>
<br>
infrastructure map server 2012 w/ Studio.<br>
<font color="#888888"><br>
--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/Feature-source-join-works-on-table-but-not-view-tp6864468p6864468.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/Feature-source-join-works-on-table-but-not-view-tp6864468p6864468.html</a><br>
Sent from the MapGuide Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</font></blockquote></div><br><br clear="all"><br>-- <br>Zac Spitzer <br>Solution Architect / Director<br>Ennoble Consultancy Australia<br><a href="http://www.ennoble.com.au">http://www.ennoble.com.au</a><br><a href="http://zacster.blogspot.com">http://zacster.blogspot.com</a><br>
+61 405 847 168<br><br><br><br>