I can not confirm this but an alternative solution would be to use a
materialized view and an update trigger on the DB size. This would
effectively stop the data in GeoServer from changing during the day. Just a
thought.
Vera
On Fri., Jun. 4, 2021, 10:57 a.m. Bart Zwemmer | GIS Specialisten, <
b...@gisspecialisten.nl> wrote:
> Hi All,
>
>
>
> We have a database table that is being edited during the day, but is also
> used as the source of a Geoserver service. We noticed the performance is
> lacking. My suspicion is that the GeoWebCache is not being used, because
> the data is always newer. Therefore I have set the following parameters on
> the Tile Cache page of the layer:
>
>
>
> Expire server cache after n seconds: 28800
>
> Expire client cache after n second: 28800
>
>
>
> My assumption is that now the cache will only update every 28800 seconds
> (8 hours), but after reading the documentation, I am not completely sure.
> Can someone confirm this for me? Or is there another way to delay cache
> updates to (for example) only 3 times per day?
>
>
>
> Thanks,
>
>
>
> Bart Zwemmer
>
> *Disclaimer*
> De informatie in dit e-mailbericht, inclusief eventuele bijlage(s) is
> vertrouwelijk en uitsluitend bestemd voor de geadresseerde(n). Gebruik van
> deze informatie door anderen dan de geadresseerde(n) is niet toegestaan.
> Openbaarmaking, verspreiding en/of verstrekking van deze informatie aan
> derden wordt niet gepermitteerd. Wanneer u dit bericht ten onrechte heeft
> ontvangen, dient u de afzender hiervan per e-mail op de hoogte te brengen
> en dit bericht te verwijderen.
> ___
> Geoserver-users mailing list
>
> Please make sure you read the following two resources before posting to
> this list:
> - Earning your support instead of buying it, but Ian Turton:
> http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines:
> http://geoserver.org/comm/userlist-guidelines.html
>
> If you want to request a feature or an improvement, also see this:
> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>
>
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
___
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
