Don't be so quick to down SQL Server. Make sure you have correct spatial indexes. Make sure the geometry is valid. It is quick, you just need to make sure you are using it properly. in my experience, it is MUCH quicker than file based.
Martin ________________________________________ From: mapguide-users-boun...@lists.osgeo.org [mapguide-users-boun...@lists.osgeo.org] On Behalf Of prabhat30 [lonely_prab...@yahoo.co.in] Sent: Wednesday, April 06, 2011 8:21 AM To: mapguide-users@lists.osgeo.org Subject: [mapguide-users] RDBMS connection performance in Mapguide Hi friends, I created an application, having a map containing SDF connection which is having very good performance but when i am using same map with sql server spatial provider connection map performance became very poor. i want to use RDBMS connection in my application because i have to do some adding & editing operation on map. so please suggest me some other RDBMS connections which provides batter performance then sql server 2008 connection. regards Prabhat -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/RDBMS-connection-performance-in-Mapguide-tp6245821p6245821.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
