Dear list
I didn’t receive any reply (yet) on my last question, so I might as well try again. Same topic, other question.
Defining a sqlserver datastore (in geoserver 2.8.1) I have the possibility to
· Check “Force spatial index usage via hints”
· Fill “Table hints”
Two questions
· Is this functioning?
· What input is expected in Table hints? I suppose the name of a spatial index. But what If I use the same store to access more than one table?
Thanks
···
Bart Verbeeck
Afdeling Geodiensten - Dienst IT
T 09 276 14 78 | bart.verbeeck@anonymised.com… | www.agiv.be
Van: Bart Verbeeck [mailto:Bart.Verbeeck@anonymised.com]
Verzonden: maandag 18 januari 2016 10:31
Aan: geoserver-users@lists.sourceforge.net
Onderwerp: [Geoserver-users] sqlserver datastore wfs
Dear list
I have found some posts about sqlserver performance issues when doing wfs requests an large datasets.
Sqlserver chooses a non-optimal queryplan when doing a spatial query with sqlserver native paging.
Without native paging sqlserver is slow when performing non spatial requests
This happens when geoserver sends a query with a combination of “SELECT top xxx” and “SHAPE”.Filter(….).
This kind of query is slow because the queryplan decides not to use the spatial index.
Unfortunately it is not possible to specify a query hint [with(index(indexname))] because sqlserver throws an error when no spatial filter is specified.
· What is the status of this issue?
· Does anyone know a workaround for this problem?
Thanks
Bart Verbeeck
Afdeling Geodiensten - Dienst IT
T 09 276 14 78 | bart.verbeeck@anonymised.com… | www.agiv.be
AGIV e-mail disclaimer: http://www.agiv.be/gis/organisatie/?artid=355