We have one site where Feature Joins are used extensively but they must be setup properly (indexes, isnull, SDF indexes, one to one joins and using roles to limit tables) and we use them in conjunction with automated procedures. We have found that when we modify the session map using just FDO ODBC connections for points in .NET it takes approximately 5 seconds (2 of actual processing) however if we use a combination of SDF/ODBC it is about 1/10 of a second. Can't explain why that would be...but it means we process the coordinates into an SDF and then join to the db for the attributes. The Feature Joins are also used for dynamic theming on this site.
Jackie Ng wrote: > > Hi All, > > I was wondering if anyone uses this feature (pardon the pun). > > When I first started with MapGuide, this was the feature that was of most > interest to me as it seemed like an easy way to link spatial data with > whatever non-spatial databases we have around. > > But after many bad experiences with performance, and some really nasty > join bugs (mainly http://trac.osgeo.org/mapguide/ticket/502), I've have > totally shunned using feature joins, and either resorting to either > pre-joining, baking the data and refreshing the dataset at regular > intervals, or using a spatially enabled rdbms that does the joins at the > dbms level. > > I've have followed the best practices guide, but is seems every database I > have encountered has its own set of quirks that don't play nice with > MapGuide. > > Most of our clients were sold on the feature joins capability (well by my > sales colleagues anyway), and it pains me (as an implementer, one to has > to deliver) to have to workaround this feature because it fails to perform > at a satisfactory level. > > I'd like to hear other people's experiences with feature joins. Is your > experience better/worse? > > - Jackie > -- View this message in context: http://n2.nabble.com/Does-anyone-use-Feature-Joins--tp1646599p1648481.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
