Re: [Geoserver-users] Layer very slow to display

2015-10-26 Thread Edward Mac Gillavry
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.hi...@gmail.com
To: emacgilla...@hotmail.com
CC: r...@russ-hore.co.uk; 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 
"100" 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 +
> 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=1.1.0=GetMap=DRIIHM:znieffs==-5.14112752212846,41.329845
> 4351757,9.55966584021411,51.090843415036=768=509=EPSG:4326=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
> ht

Re: [Geoserver-users] Layer very slow to display

2015-10-23 Thread Edward Mac Gillavry
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 +
> 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=1.1.0=GetMap=DRIIHM:znieffs==-5.14112752212846,41.329845
> 4351757,9.55966584021411,51.090843415036=768=509=EPSG:4326=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
  --
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] Layer very slow to display

2015-10-23 Thread russ
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=1.1.0=GetMap=DRIIHM:znieffs==-5.14112752212846,41.329845
4351757,9.55966584021411,51.090843415036=768=509=EPSG:4326=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


[Geoserver-users] Layer very slow to display

2015-10-23 Thread Georges H
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=1.1.0=GetMap=DRIIHM:znieffs==-5.14112752212846,41.3298454351757,9.55966584021411,51.090843415036=768=509=EPSG:4326=application/openlayers

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


Re: [Geoserver-users] Layer very slow to display

2015-10-23 Thread Georges H
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
"100" 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 +
> > 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=1.1.0=GetMap=DRIIHM:znieffs==-5.14112752212846,41.329845
> >
> 4351757,9.55966584021411,51.090843415036=768=509=EPSG:4326=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