Hello, Bart.
Sorry about the lack of response. I was using Geoserver with SQL Server
initially, but it performed poorly. On the other hand, Geoserver and
PostGIS work really nicely together, so I now install PostGIS and Geoserver
on the same server, and replicate my data to PostGIS. (This might not be
what you wanted to hear.)
Regards,
David Collins
Geological Survey of NSW
On Mon, Jan 18, 2016 at 8:31 PM, Bart Verbeeck <[email protected]>
wrote:
> 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] | 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
>
>
------------------------------------------------------------------------------
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=272487151&iu=/4140
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
