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 Garnett wrote:
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 using the default H2 database or PostgreSQL?
You can see where a similar issue has been previously fixed on
GEOS-5968
<https://urldefense.proofpoint.com/v1/url?u=http://jira.codehaus.org/browse/GEOS-5968&k=AjZjj3dyY74kKL92lieHqQ%3D%3D%0A&r=E51gnZ%2BcyXbMGQZxn%2FD1gw7E4%2FG%2Bn9A8lGzpPjSUKD4%3D%0A&m=QuiunhjzwhnjewJu0voBPL5xU9BTeRCly%2FT0GlLQuMU%3D%0A&s=400dfc1485c4e3d5c7a32c02aefc08aff7221b25096fa8dda0ddbf0683eab7b1>.
Jody Garnett
On Wed, Mar 12, 2014 at 4:09 AM, Matt Bertrand
<[email protected] <mailto:[email protected]>> wrote:
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 accessing the list of layers from the
administration interface and paging through results. However,
after Geoserver is restarted, or if the configuration/catalog is
reloaded from the admin interface, then it becomes far slower -
taking over 2 minutes to display each page of layers from the
admin interface.
I connected to the code running in my Tomcat instance remotely via
Eclipse and it seems that this line in the ConfigDatabase class is
where it takes so long to process:
https://github.com/geoserver/geoserver/blob/master/src/community/jdbcconfig/src/main/java/org/geoserver/jdbcconfig/internal/ConfigDatabase.java#232
<https://urldefense.proofpoint.com/v1/url?u=https://github.com/geoserver/geoserver/blob/master/src/community/jdbcconfig/src/main/java/org/geoserver/jdbcconfig/internal/ConfigDatabase.java%23232&k=AjZjj3dyY74kKL92lieHqQ%3D%3D%0A&r=E51gnZ%2BcyXbMGQZxn%2FD1gw7E4%2FG%2Bn9A8lGzpPjSUKD4%3D%0A&m=QuiunhjzwhnjewJu0voBPL5xU9BTeRCly%2FT0GlLQuMU%3D%0A&s=e14c7842550b0d024558f47f1595a50fe162c1ab34f1a03feb72249a8ba1c2a6>
The same line returns quickly immediately after the initial
catalog import. But I haven't yet been able to figure out why.
Could it be that I simply have some setting misconfigured, or that
there's something wrong with my data catalog?
-Matt
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases
and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
<https://urldefense.proofpoint.com/v1/url?u=http://p.sf.net/sfu/13534_NeoTech&k=AjZjj3dyY74kKL92lieHqQ%3D%3D%0A&r=E51gnZ%2BcyXbMGQZxn%2FD1gw7E4%2FG%2Bn9A8lGzpPjSUKD4%3D%0A&m=QuiunhjzwhnjewJu0voBPL5xU9BTeRCly%2FT0GlLQuMU%3D%0A&s=c43f27d2e71609b9136c7f688669205c45674deb105b9cd86af257d51c971fac>
_______________________________________________
Geoserver-users mailing list
[email protected]
<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
<https://urldefense.proofpoint.com/v1/url?u=https://lists.sourceforge.net/lists/listinfo/geoserver-users&k=AjZjj3dyY74kKL92lieHqQ%3D%3D%0A&r=E51gnZ%2BcyXbMGQZxn%2FD1gw7E4%2FG%2Bn9A8lGzpPjSUKD4%3D%0A&m=QuiunhjzwhnjewJu0voBPL5xU9BTeRCly%2FT0GlLQuMU%3D%0A&s=bc1ad5fdfeaa1f69a89321831ced0de3ef86a20b51c1a4afe9d4fc387b8b30d6>
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
