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 | [email protected]<mailto:[email protected]> |
www.agiv.be<http://www.agiv.be/>
________________________________
AGIV e-mail disclaimer: http://www.agiv.be/gis/organisatie/?artid=355
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
