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: [email protected] > To: [email protected]; [email protected] > 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 <[email protected]> > > To: geoserver-users <[email protected]> > > 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 > > [email protected] > > [email protected] > > _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 > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > > > ------------------------------------------------------------------------------ > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
