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 "<MaxScaleDenominator>1000000</MaxScaleDenominator>" 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 <emacgilla...@hotmail.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: r...@russ-hore.co.uk > > To: georges.hi...@gmail.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.hi...@gmail.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.hi...@gmail.com > > > georges.hi...@mnhn.fr > > > _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.hi...@gmail.com georges.hi...@mnhn.fr *Tél : 01 40 79 80 44* *Tél : 06 47 61 84 92* Le site du LabEx DRIIHM <http://www.driihm.fr/> Le métacalogue du LabEx DRIIHM <http://geo-driihm.fr/catalogue/srv/fre/catalog.search#/home>
------------------------------------------------------------------------------
_______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users