[mapguide-users] Database Comparisons/Reviews/Recommendations

[Zac Spitzer]

Based on benchmarking presented at Foss4g last year, PostGIS
is the fastest spatial database that I am aware of, it's also free.

Autodesk recently developed a new PostGIS FDO provider which
is much better than the previous community developed FDO
provider was somewhat buggy.

z



On 31 August 2010 08:37, Steve G <steve.golden at morganhill.ca.gov> wrote:
>
> Sorry if this has already been posted before (I did a search, but didn't find
> much).  I am currently running MGOS 2.1 on a Win2003 Server with all of my
> geospatial data in shapefiles (about 60 layers; unmanaged resources on a
> network file server; probably will upgrade to Win2008 Server soon).  It
> actually runs quite well with the data I have, however, just looking into
> the future and thinking about migrating the data into an actual spatial
> database.  I was wondering if there are any case
> studies/reviews/comparisons, etc of the freely available databases or if you
> just want to respond with your own experiences.  I know it ultimately
> depends on what I want the database to do, but hoping to leverage the
> knowledge of other users before making a decision.  Some things I would be
> interested in are:
>
> -Database capabilities
> -Scalability (size limitations; connection limmitations; schema locking when
> editing; etc)
> -How easy to manage?
> -Performance/Speed
> -Major Bugs/Issues using with Mapguide
> -Major Bugs/Issues using with current FDO providers
>
>
> Thanks for any input.  If there is a lot of feedback, I will try to combine
> and place in a better spot (back in the Mapguide OSGEO website).
> --
> View this message in context: http://osgeo-org.1803224.n2.nabble.com/Database-Comparisons-Reviews-Recommendations-tp5480460p5480460.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