[mapguide-users] RE: RDBMS connection performance in Mapguide

[Zac Spitzer]

Thanks for that great explanation Traian!

I would suggest that PostGIS is probably the best choice if your going
to pick a spatial database server, as it's the most complete free
actively maintained
implementation, plus outperforms Oracle ( google FOSS4G WMS Shootout stats)

z

On Thu, Apr 7, 2011 at 12:55 PM, Traian Stanev
<traian.stanev at autodesk.com> wrote:
>
> In the limit, fetching data from an in-process, close to native representation (e.g. SQLite) will significantly outperform an out-of-process (and possibly remote machine) based RDBMS, at the very least due to the latency and inter-process communication involved.
>
> One could claim that the performance difference could be introduced by differences in the FDO translation layer (e.g. SQLite translation being hypothetically slower than other RDBMS), but this is not the case in FDO.
>
> The above assumes simple queries, as generally required by MapGuide rendering, given that the original question was about MapGuide.
>
> Traian
>
>
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Jackie Ng
> Sent: Wednesday, April 06, 2011 9:04 PM
> To: mapguide-users at lists.osgeo.org
> Subject: [mapguide-users] RE: RDBMS connection performance in Mapguide
>
> Agreed.
>
> You shouldn't automatically dismiss SQL Server's performance (or any other
> RDBMS) just because MapGuide may give a very bad impression of it.
>
> There are entire books written and tons of Google results about this particular subject (DB design and optimisation). All MapGuide does is issue queries to your database, it doesn't know anything about indexes, execution plans, etc.
>
> - Jackie
>
> --
> View this message in context: http://osgeo-org.1803224.n2.nabble.com/RDBMS-connection-performance-in-Mapguide-tp6245821p6248246.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
> _______________________________________________
> 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