Thanks for the information. Not ideal, but perhaps I can cobble something together to get me by until performance is improved. I wonder if it would be any better to use Access as a pass-through, linking to the tables from SQL Server.
Dave Wilson-3 wrote: > > Based on some testing it appears that the ODBC provider for SQL Server > is probably the slowest of the ODBC providers. Oracle, MySQL or Access > generally perform better. Given the new support of views it appears that > queries in Access can be used. > > Regards, > Dave > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ivan > Milicevic > Sent: Wednesday, June 13, 2007 8:49 AM > To: MapGuide Users Mail List > Subject: RE: [mapguide-users] ODBC performance > > I'm trying to keep my data in SDF file. The fastest one. > > Have you tried with mySQL server? Postgre? > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jon Rizzo > Sent: Wednesday, June 13, 2007 4:48 PM > To: [email protected] > Subject: [mapguide-users] ODBC performance > > > > I just upgraded to 1.2 RC1 today and I loaded my site. It looks like > there > are a lot of great new features - the new symbolization will be > particularly > helpful to us. > > I have been having performance issues on my site, which seem to be > related > to an ODBC feature source which I have joined to an SDF feature source. > The > ODBC database is running on the same server as MapGuide. It takes > several > seconds (between 5 and 10) for the viewer to display the user's > selection, > and about the same amount of time for my page to load initially. > Depending > on who you ask, opinions of my site vary from 'annoying' to 'useless'. > The > poor performance is particularly surprising because the layer only has > about > 100 polygons on it, and the other layers are not particularly complex > either. I have posted about this issue previously & was advised that > there > would be improvements in the new version which might help. I tested my > application in 1.2 RC1 and I was disappointed to find that the upgrade > did > not have an effect on the performance of my application. Is there > anything > that can I can do to improve performance here (and not lose the ability > to > theme or label extended properties)? Is there still work being done to > address ODBC performance issues, or is my situation unique? Thanks for > any > information you can provide. > > Jon > > > -- > View this message in context: > http://www.nabble.com/ODBC-performance-tf3915161s16610.html#a11101110 > 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 > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- View this message in context: http://www.nabble.com/ODBC-performance-tf3915161s16610.html#a11182787 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
