[Geoserver-users] Layer creation in large workspaces takes a long time

Hello all!

Geoserver novice here. I'm using geoserver to provide a WMS service to
various users of a webapp. Each user has a workspace, and layers are created
within those workspaces. I'm using geoserver 2.11.1 with tomcat7.

The data is a time series of polygons (which may not have identical
geometries) and data is updated every few days. Layers are periodically
created through the REST API as data becomes available. Currently, the files
are in a data directory structure on the same server that geoserver lives
on. There are around 200,000 layers/shapefiles currently on this geoserver
instance.

Recently, I've noticed a significant slowdown when using the REST API on
workspaces with tens of thousands of existing layers. Requests are taking up
to 20 seconds to complete, and I imagine if this is the root of the problem,
it will only get worse.

Has anyone experienced this issue before? Would I be better off creating a
huge PostGIS database table and using SQL to create the layers? Any other
ideas for how this could be reduced? I'm guessing either way the slowdown
will stay the same - any help on this would be much appreciated,

Thanks!

--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html

It sounds like you would be better off with a PostGIS table as a single layer and using the WMS time dimension to choose which polygon to display.

Ian

ยทยทยท

Ian Turton