Re: [mapguide-users] Re: Shape-Files and Joins
We are currently using shapefiles with joins with good results. 2 issues affect whether features display or not. 1 is geometry related - repair geometry in ArcMap 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. No error is thrown features just appear or disappear at different zoom thresholds or all together. Performance - turn caching on for the Shape FDO in the serverconfig.ini Cheers, Kori Maleski On Tue, Feb 23, 2010 at 12:28 PM, isca wrote: > > Especially the performance makes the joins useless. > -- > View this message in context: > http://n2.nabble.com/Shape-Files-and-Joins-tp4611381p4621196.html > Sent from the MapGuide Users mailing list archive at Nabble.com. > ___ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] Re: Shape-Files and Joins
Especially the performance makes the joins useless. -- View this message in context: http://n2.nabble.com/Shape-Files-and-Joins-tp4611381p4621196.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] Re: Shape-Files and Joins
This may be a long shot, but can the randomly disappearing / reappearing features be related to a corrupt spatial index file (.IDX) and not related to the join at all? Give this a try: http://n2.nabble.com/Points-Disappearing-with-External-SHP-Connection-td4210614.html#a4211892 Good luck, Denis -- View this message in context: http://n2.nabble.com/Shape-Files-and-Joins-tp4611381p4612575.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users