Georges,
The only effect of adding MaxScaleDenominator is that the layer won’t be shown at scales smaller than 1:1.000.000. If you would like to display the ZNIEFF layer at scales smaller than 1:1.000.000 or you want fast display times than 3 or 4 seconds at scales larger than 1:1.000.000, you may want to look into generalising your features with our without the plugin.
Furthermore, adding caching headers doesn’t change anything for the server-side rendering, of course! It only controls whether the browser will take the image from the browser cache or make a new request to the server.
Edward
Date: Fri, 23 Oct 2015 19:28:49 +0200
Subject: Re: [Geoserver-users] Layer very slow to display
From: georges.hinot@anonymised.com
To: emacgillavry@anonymised.com
CC: russ@anonymised.com; geoserver-users@lists.sourceforge.net
Hi, thanks for advices !
I had already a spatial index.
Then, after yours advices, I have added another index on the gid field, without changes.
Then , always thanks to yours advices, I have added an “1000000” in my SLD. And indeed, after this, just 3 or 4 seconds are necessary to load the layer. It is better !
Then, I have added a “Header HTTP cache”. And when the layer has already been display, it display immediately ! Cool !
But do you really think that with “Pregeneralized Features” I will can improve the display speed of this layer ?
Can I just improve changing my “MaxScaleDenominator” ?
Thanks
2015-10-23 16:25 GMT+02:00 Edward Mac Gillavry <emacgillavry@anonymised.com>:
Georges,
From the link you sent along, the map scale appears to be 1:9M. Spatial indexes have their benefits when zoomed in to do a quick bounding-box comparison if I understand Geoserver workings correctly. When you are zoomed out to 1:9M, it will simply retrieve all features.
Maybe, you can add scale-dependent rules in the SLD: i.e. don’t show all features on all zoom levels. This particularly is for the ZNIEFF regions! Opening your WMS in QGIS, I zoomed in to 1:300.000 and added the ZNIEFF layer. Then, I was able to view them 
It’s not a matter of the number of ZNIEFF features, but the level of detail in their outlines. These outlines follow river beds and mountain valleys it seems. Maybe use generalised versions of these features to display these areas at smaller scales.
You can simply add new layers that have the generalised outlines in a Layergroup for ZNIEFF, or more advanced, use the GeoServer extension “Pregeneralized Features”:
http://docs.geoserver.org/latest/en/user/data/vector/featurepregen.html
Best of luck,
Edward
From: russ@anonymised.com
To: georges.hinot@anonymised.com; geoserver-users@lists.sourceforge.net
Date: Fri, 23 Oct 2015 11:37:54 +0000
Subject: Re: [Geoserver-users] Layer very slow to display
Is it a lack of an index on the table?
Russ
-------Original Message-------
From: Georges H <georges.hinot@anonymised.com>
To: geoserver-users <geoserver-users@lists.sourceforge.net>
Subject: [Geoserver-users] Layer very slow to display
Sent: 23 Oct '15 11:28
Hi
I have a layer very slow to display (from a Postgres DB), I do not
understand why, beacause I have other layers which I think to be more
bigger, without problem, and also from Postgres DB.
Here for example:
http://cartoperso.com/gs271/DRIIHM/wms?
service=WMS&version=1.1.0&request=GetMap&layers=DRIIHM:znieffs&styles=&bbox=-5.14112752212846,41.329845
4351757,9.55966584021411,51.090843415036&width=768&height=509&srs=EPSG:4326&format=application/open
layers
What do you think about ? Are there ways to improve the display speed
on Geoserver,
Thank you !
GEORGES HINOT
CNRS - DRIIHM - UMS BBEES (3468)
Musée d’Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
Tél : 01 40 79 80 44
Tél : 06 47 61 84 92
Le site du LabEx DRIIHM
Le métacalogue du LabEx DRIIHM
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
Georges Hinot
CNRS - DRIIHM - UMS BBEES (3468)
Musée d’Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
Tél : 01 40 79 80 44
Tél : 06 47 61 84 92
Le site du LabEx DRIIHM
Le métacalogue du LabEx DRIIHM
