We are keeping around 75.000 spatial objects in a MSSQL Spatial database.
Simple features - just squares in a grid system. Our geoserver defined layers
combine the spatial data through joins from rather big tables (2.500.000 and
2.100.000) through various parameters. We connect to the Microsoft SQL as a
normal vector data source.
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.
Still - we have to consider our options. So we took a look at the good old
ArcSDE extension (http://docs.geoserver.org/latest/en/user/data/arcsde.html).
It seems like not much has happened here on the development side. Our current
operating environment is ArcSDE 9.2 SP4, but I am told that we on a client side
could use a higher version. Would this theoretically help us to speed up
things?
Other ideas for speeding up things are more than welcome!
Cheers,
Ragnvald
(geoblog: www.mindland.com)
Senior Engineer, Environmental data section
Tlf: +47 73 58 05 64
Mob: +47 92 42 15 40
The Norwegian Directorate for Nature Management
www.dirnat.no<http://www.dirnat.no>
------------------------------------------------------------------------------
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
