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