Hi Yang,
Things you have to consider: - do the layers (the data) make sense being individually queried? If not it's better to use a view - will the individual layers be subject to updates via wfs? If yes then obviously you cannot use a database view for that - as you said with a database view the capabilities response does not know anything about the underlying tables... - does the data change often? If not you should consider tile caching to release pressure from DB Yang <dh...@foxmail.com> escreveu no dia sexta, 29/05/2020 à(s) 16:11: > I have more than 10+ layers published from a postgis datastore, and I have > created a layer group for them. > > Now I wonder how does geoserver load data for a wms request for this layer > group? Query each layer by the bbox one by one? If this is true, I am not > sure if this will cause pressure to the database. > > I have though that maybe I can create a view for the layers, but if so, > the database view may be seen as a single wms layer in the capabilities > request. > > Any suggestion? > > _______________________________________________ > 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 > -- www.vfonsecaz.pt
_______________________________________________ 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