We are currently using shapefiles with joins with good results.<br><br>2 issues affect whether features display or not.<br><br>1 is geometry related - repair geometry in ArcMap<br>2 is the join field. If the Shapefile ID is text, so must the SQL table. If there are null IDs in the shapefile, the join may fail.<br>
<br>No error is thrown features just appear or disappear at different zoom thresholds or all together.<br><br><br><br>Performance - turn caching on for the Shape FDO in the serverconfig.ini<br><br><br><br><br>Cheers,<br><br>
Kori Maleski<br><br><br><br><br><br><br><div class="gmail_quote">On Tue, Feb 23, 2010 at 12:28 PM, isca <span dir="ltr"><<a href="mailto:mapguide2007@gmail.com">mapguide2007@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
Especially the performance makes the joins useless.<br>
<font color="#888888">--<br>
View this message in context: <a href="http://n2.nabble.com/Shape-Files-and-Joins-tp4611381p4621196.html" target="_blank">http://n2.nabble.com/Shape-Files-and-Joins-tp4611381p4621196.html</a><br>
</font><div class="im">Sent from the MapGuide Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
</div><div><div></div><div class="h5">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>
</div></div></blockquote></div><br>