We have a client who is also benchmarking sql server and finding even with
WKB things aren't ideal for them. Basically from what we can tell even
though the driver now uses wkb that still involves an expensive conversion
on the server that uses up resources. What we would like to do is add an
option for using "native" mode, that is parse the sql server geometries in
there native serialization format.
This is the default option for ogr.
http://www.gdal.org/ogr/drv_mssqlspatial.html
On Wed, May 16, 2012 at 3:03 AM, Andrea Aime
<andrea.a...@geo-solutions.it>wrote:
> On Wed, May 16, 2012 at 10:49 AM, Ragnvald Larsen
> <ragnvald.lar...@dirnat.no> wrote:
> > We expect a fair number of users on our system and are now doing some
> > capacity testing. Currently it looks like one wms-request takes around 6
> > seconds to process for the whole area. The SQL operation for the join is
> not
> > the problem. Our consultants has informed us that our current version of
> > Geoserver (2.1.3) has to get the geometries as WKT from MSSQL. Testing
> with
> > Geoserver 2.2 beta indicates that this version handles the job
> differently –
> > geometries are subject to a binary cast. But we are looking for ways to
> > speed up things. It seems like our twin geoservers are quite relaxed,
> while
> > the MSSQL server is busy. One way forward is to up our virtual MSSQL
> server
> > memory somewhat (from 48Gb) and we are hoping to see performance
> increase
> > with more users active.
>
> Just a note here, GeoServer 2.1.4 will also use binary encoding (WKB),
> which
> is supposedly faster on both ends (GeoServer to parse it, MSSQL to encode
> it),
> you can already try it out in a nightly build:
> http://gridlock.opengeo.org/geoserver/2.1.x/
>
> The source code for the sql server store is here, maybe you can find
> other ways to
> speed it up?
>
> http://svn.osgeo.org/geotools/branches/2.7.x/modules/plugin/jdbc/jdbc-sqlserver/src/main/java/org/geotools/data/sqlserver/
>
> 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
> mob: +39 339 8844549
>
> 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
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
