Re: [Geoserver-users] jdbcconfig - performance issue with 11K layers

2014-03-13 Thread Kevin Smith
The function is checking if the the Advertised and Enabled flags are set on the layer, or its resource, or for layer groups it's either always returning true or checking each sublayer depending on the specified visibility policy. It also checks if the request is a GetCapabilities request and only

Re: [Geoserver-users] jdbcconfig - performance issue with 11K layers

2014-03-13 Thread Andrea Aime
On Thu, Mar 13, 2014 at 4:56 PM, Matt Bertrand wrote: > It's an "IsEqualsToImpl" filter - same type of filter before and after > the slowdown. I created a new JIRA issue for this - > https://jira.codehaus.org/browse/GEOS-6398, just wanted to run the > problem by this list first though to see if

Re: [Geoserver-users] jdbcconfig - performance issue with 11K layers

2014-03-13 Thread Matt Bertrand
It's an "IsEqualsToImpl" filter - same type of filter before and after the slowdown. I created a new JIRA issue for this - https://jira.codehaus.org/browse/GEOS-6398, just wanted to run the problem by this list first though to see if it might be a known issue caused by a misconfigured setting

Re: [Geoserver-users] jdbcconfig - performance issue with 11K layers

2014-03-12 Thread Jody Garnett
Well if you are into looking at code - perhaps stop it in a debugger and see what filter it is having trouble optimising? At the very least we can use that information to report a new JIRA issue. Jody Garnett On Thu, Mar 13, 2014 at 7:00 AM, Matt Bertrand wrote: > Thanks Jody, > > I have trie

Re: [Geoserver-users] jdbcconfig - performance issue with 11K layers

2014-03-12 Thread Matt Bertrand
Thanks Jody, I have tried using both the PostgreSQL and H2 database, with the same result. And what's odd is that the same line of code is executed when Geoserver initially responds quickly as when it later responds slowly. Maybe it's a caching issue? -Matt On 03/11/2014 09:41 PM, Jody

Re: [Geoserver-users] jdbcconfig - performance issue with 11K layers

2014-03-11 Thread Jody Garnett
Looks more like a limitation of the implementation, just before the line you mention the code has: LOGGER.fine("Filter is not fully supported, doing scan of supported part to return the number of matches"); So I expect work is required to ensure that database can handle the query. Are you usin

[Geoserver-users] jdbcconfig - performance issue with 11K layers

2014-03-11 Thread Matt Bertrand
Hi, I've been trying out the jdbcconfig module with a data catalog of about 11,500 layers (~1000 geotiffs, a few hundred shapefiles, and the rest in a PostGIS datastore). Immediately after the initial import of the data catalog, the responsiveness of Geoserver seems fine, for instance when a