[mapguide-users] RDBMS connection performance in Mapguide

[Dave Wilson]

Try using MySQL. It's pretty quick.

Dave

-----Original Message-----
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

z

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
> 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 at 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 at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users