Re: [Geoserver-users] Geoserver 2.12.1 and spatial index.

2018-02-04 Thread Andrea Aime
On Sun, Feb 4, 2018 at 5:50 PM, adrianap sanchez wrote: > You are right, I want to try rigth now, the improved extension that you > implemented in geoserver, and if you want I can post the results , to the > list. > Yes, please do, I believe others would be curious to see your results as well.

Re: [Geoserver-users] Geoserver 2.12.1 and spatial index.

2018-02-04 Thread adrianap sanchez
A greeting Andrea Aime and Rahkonen. Andrea Aime, in first place congrats for your work and for the effort that you put around the geoserver, and thank you so much for answer me. You are right, I want to try rigth now, the improved extension that you implemented in geoserver, and if you want I ca

Re: [Geoserver-users] Geoserver 2.12.1 and spatial index.

2018-02-04 Thread Andrea Aime
On Sun, Feb 4, 2018 at 3:57 PM, Rahkonen Jukka (MML) < jukka.rahko...@maanmittauslaitos.fi> wrote: > Did you do your test with a big BBOX or a small BBOX? In the first case no > speed-up is what you can await but in the latter case the spatial index > should give noticeable improvement. Here is so

Re: [Geoserver-users] Geoserver 2.12.1 and spatial index.

2018-02-04 Thread Rahkonen Jukka (MML)
Hi, Spatial index can only speed up the data access if it leads to selective query. In practice it means that the bounding box of the query is small. If your GetMap is reading the whole extent of your data then every single feature from the data must be read. In that case spatial index makes th