On 17-12-18 16:06, Cliff Patterson wrote:
Hi Sorin,
All very good suggestions! Big thanks! I do like your final idea about
"materialized views". I was thinking the same thing since a simple
crontab job (at least in my Linux/PG world) would do it nicely.
No materialized views in ms sql server, you can however create indexed
views (it depends on the view defnitions, I agree it can be painful)
I might also try to export the data and import them into PG/PostGIS to
see if there are any obvious gains in performance. But first, I am going
to tinker more with SQL Server and try your suggestions.
FWIW My limited experience shows that on the same hardware/os sqlserver
gets about half of the perf that postgis does.
Compare eg. the integration test results of
https://travis-ci.org/B3Partners/brmo (PostgreSQL 10 vs. ms SQL Server
2017) note these testsuites are mostly doing inserts
-M
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
