[mapguide-users] RDBMS connection performance in Mapguide
dave.wilson at autodesk.com
Wed Apr 6 11:01:37 EDT 2011
Try using MySQL. It's pretty quick.
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at 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
On Wed, Apr 6, 2011 at 10:21 PM, prabhat30 <lonely_prabhat at 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
> 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 at lists.osgeo.org
Solution Architect / Director
Ennoble Consultancy Australia
+61 405 847 168
mapguide-users mailing list
mapguide-users at lists.osgeo.org
More information about the mapguide-users