I use Geoserver (2.0.2 at the moment) with Microsoft SQL Server 2008
(internally only) with datasets having tens of thousands of points, and I
would echo Andrea's sentiments.
When we were using the 32-bit version of MSSQLServer 2008 the database was
unstable when working with tables containing a spatial field. Going to
64-bit has fixed the stability problems, but the 64-bit version is slower
than the 32-bit version. Both nightly replication jobs and Geoserver run
about twice as slow as previously.
After trying various ways to speed up Geoserver, I did a very quick install
and test of PostGIS on an under-powered virtual server, and
Geoserver-to-Google-Earth delivery was about 2.5 times faster than using
data from MSSQL 2008 on more powerful hardware. It would be good to see a
comparison on equal hardware.
On Fri, May 13, 2011 at 1:55 AM, Andrea Aime
<andrea.a...@geo-solutions.it>wrote:
> On Thu, May 12, 2011 at 2:21 PM, Ragnvald Larsen
> <ragnvald.lar...@dirnat.no> 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
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
------------------------------------------------------------------------------
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
