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<http://jira.codehaus.org/browse/GEOS-5968>
.
Jody Garnett
On Wed, Mar 12, 2014 at 4:09 AM, Matt Bertrand <[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
>
> 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
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
------------------------------------------------------------------------------
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
