Try using MySQL. It's pretty quick. Dave
-----Original Message----- From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Zac Spitzer Sent: Wednesday, April 06, 2011 6:42 AM To: MapGuide Users Mail List Subject: Re: [mapguide-users] RDBMS connection performance in Mapguide what's your server setup? separate db server? File based providers have much less overhead and outperform DB servers period. sqlite is by far the best, roughly 3-4 x SDF, 20-40x RDBMS best approach is too keep static data in sqlite, dynamic in RDBMS z On Wed, Apr 6, 2011 at 10:21 PM, prabhat30 <lonely_prab...@yahoo.co.in> wrote: > 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 > -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia http://www.ennoble.com.au http://zacster.blogspot.com +61 405 847 168 _______________________________________________ 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