I was told specifically the oposite - that ODBC performance of SQL Server is slower than all other ODBC providers, including Access. I have not verified this claim, but I can tell you that selection is particularly slow with points coming from SQL Server. I have also had a performance problem selecting polygons if they are joined with data coming from SQL Server. I don't know enough about the problem to know if this is a MapGuide or a Microsoft issue but selection on my site is terribly slow because of this.
Jon None None-9 wrote: > > Is anyone using ODBC to Access to display point layers on a production > server? Are there known issues with selecting and overall speed? I am > assuming yes, and if so has anyone used MS SQL for the same thing and > notices an improvment with the Enterprise FDO? > > The Rock > > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- View this message in context: http://www.nabble.com/ODBC-Points-Performance-tf4201424s16610.html#a11951968 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
