I have an SQL View layer working that's pulls from a PostGIS DB. It has 2 viewparams concatenated to my wms strings like this:
&viewparams=dayval:1;hourval:1 dayval can be 1 to 365 while hourval which can be 1 to 24. This works fine except for performance as no cache is being generated that I can see. It takes almost 3 seconds for each wms request to be served for the full layer of 73000(ish) geom's. So from various web searches I came across a post that says I need to set a parameter filter based on these docs. https://docs.geoserver.org/latest/en/user/geowebcache/webadmin/layers.html#parameter-filters Tile Layers — GeoServer 2.23.x User Manual<https://docs.geoserver.org/latest/en/user/geowebcache/webadmin/layers.html#parameter-filters> Tile Layers¶. This page shows a listing of all of the layers known to the integrated GeoWebCache. It is similar to the Layer Preview for GeoWebCache, with many of the same options. docs.geoserver.org In the 'Edit Layer->Tile Caching' tab I have added a Parameter Filter. I set a 'VIEWPARAMS' filter as 'List of Whole Numbers' with a range of 1 to 365. It seems I can't add a second 'VIEWPARAMS' filter to account for the 1 to 24 range, although maybe I don't need to. However, I still don't see a cache building. Is there something obvious I'm doing wrong. Could it be an issue as to when the filter gets applied. The SQL View only returns 2 fields like this: SELECT geom, emmision FROM table WHERE day = dayval and hour = hourval So is the Parameter Filter acting on the returned data? Maybe I need a different approach altogether!! Thanks, Paul
_______________________________________________ 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
