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
