Hexagon Geospatial
MENU

WebGIS

Need a push in the right direction when configuring WebMap, Portal or SDI services? Looking for hints and tips, or just looking for Ideas and information? The WebGIS discussion board is where you start those discussions, connect and share information.
Showing results for 
Search instead for 
Do you mean 
Reply
Contributor
Posts: 28
Registered: ‎01-14-2016

WMS and SQL Server Spatial

Hi all,

 

Does anyone aware if there are any guidelines or someone's experience in tuning / setting spatial database in MS SQL Server?

We make GIS projects for corporate customers (dozens, hundreds users, 100+ layers, dozens WMS, etc.).

We use GeoMedia WebMap + SDI + Geospatial Portal.

We'd like to achieve better performance for web customers.

 

Thank you,

Kirill

 

Super Contributor
Posts: 334
Registered: ‎10-12-2015

Re: WMS and SQL Server Spatial

Attached is an old copy of GMPSpatialUtilities - 'GeoMedia Spatial Data Utilities for SQL Server spatial data'.

Has not been maintained for years, but still works.

If your not familiar with creating SQL Server spatial indexes it can help. Please keep in mind it was written back in 2013/2014 so may not be right up to date with latest SQL Server spatial indexing optimization but should provide a start.

Provided as is were is.

Run the .sql file attached against a database to deploy it.

Then exec GMPCreateSpatialIndexes which will create any missing indexes. Can also use GMPDropSpatialIndexes prior to drop existing indexes if they need recreating.

 

Otherwise typical dba - database stuff

If still not fast enough could consider publishing from SQL Server spatial to GeoMedia SmartStore. You would then need to republish on a periodically basis and manage / maintain the SmartStores and processes. Can do that from a Windows task scheduler. I'm not sure of current figures, but about 5 years ago indicative figures was that SmartStore was around 30% faster than source database - dependent on a lot of environmental factors though. https://hexagongeospatial.fluidtopics.net/reader/BeGuPafzOAVuNDX2NE~ghg/SQkwlWFSTfNIw6NpHkygbw 

Occasional Contributor
Posts: 13
Registered: ‎10-18-2017

Re: WMS and SQL Server Spatial

Hi Kirill,

 

Along with the spatial indexing plans, you can perform some other useful tasks that can affect the rendering of data over web:

 

a) Check for duplicate data and remove them.

b) Simplify geometry to reduce nodes for layers wherever you can.

c) You should use GeoMedia Desktop to create scale based rendering of your layers (It's very effective)

d) Partition your data and divide them in multiple databases in SQL server and do indexing for primary keys and columns you will extensively use.

e) Use WMTS against WMS

f) Keep WMPS specifically for querying

 

Thanks

 

Regards!

Aroop

Polls
Please register to vote
Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Service Request through our Support Portal.