[mapguide-users] RDBMS connection performance in Mapguide

[Zac Spitzer]

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