On Thu, May 12, 2011 at 2:21 PM, Ragnvald Larsen <[email protected]> wrote: > We are hosting a fair amount of data on MSSQL server 2008 spatial. We are > currently using ArcGIS server and ArcIMS(!) to forward this data according > to the WMS standard. > > > > We have earlier tried using this plugin with Geoserver 2.1 RC2: > > > > http://docs.geoserver.org/stable/en/user/data/sqlserver.html > > > > What could we expect with regards to stability, predictability and capacity > using this plugin on Geoserver 2.1. We earlier got a couple of “exclamation > marks” and hung connections. This experience was as I mentioned based on > using on RC2 on a VERY small scale. What we are looking for is better > documentation and some success examples – if possible. > > > > This is necessary for Geoserver to prove itself as an alternative to ArcGIS > Server and/or Mapserver.
All the big deploys run on top of Oracle or PostGIS as far as I know. I'm talking about clusters of GS serving hundreds of millions of rows. The SQLServer store is maintained in spare time but there is, as far as I know, no developer actually using it in production. PostGIS is maintained because all devs like it, Oracle is maintained because it drives business, SQLServer seems to be stuck in a limbo where no core developer is actually using it, no one using it wants to step up and become a maintainer, nor it drives any kind of business (that I know of). I believe we'll move forward the day someone decides to put the time/money where the mouth is and get it pushed up to the PostGIS/Oracle level. Cheers Andrea -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- ------------------------------------------------------------------------------ Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
