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 <[email protected]> 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 > [email protected] > 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
