I have a GeoServer instance and have imported multiple high res tiff files as layers and created a layergroup from the layers. When I call the WMS endpoint with a specified bbox and the geopackage format, it can take multiple hours to get the geopackage from the server. It appears when my gridset includes zoom levels 19 or above is when I begin to see the time increase exponentially. A jpeg or PNG returns quickly.
Are there optimizations that can be made either to the query or to how we are organizing our layers that could help? Even if the bbox provided is within a single layer, the query against the layer group is extremely slow.
Example query: http://localhost:8080/geoserver/wms?service=WMS&version=1.1.1&request=GetMap&layers=TestWKSP:TestLGroup&bbox=627883.09857,8299208.89693,628180.15347,8299506.25009&width=500&height=500&srs=EPSG:32735&format=geopackage&format_options=min_zoom:8;max_zoom:21;tileset_name:neighborhood&transparent=true