Steve Ikeoka ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Ac68be705-e740-4b23-b796-c04c7a01eaf3 ) *created* an issue
GeoServer ( https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiMDIxN2FiNTA4MmNjNGI0YmJkZmFkNGZmYmNkMDkyZjciLCJwIjoiaiJ9 ) / Bug ( https://osgeo-org.atlassian.net/browse/GEOS-10981?atlOrigin=eyJpIjoiMDIxN2FiNTA4MmNjNGI0YmJkZmFkNGZmYmNkMDkyZjciLCJwIjoiaiJ9 ) GEOS-10981 ( https://osgeo-org.atlassian.net/browse/GEOS-10981?atlOrigin=eyJpIjoiMDIxN2FiNTA4MmNjNGI0YmJkZmFkNGZmYmNkMDkyZjciLCJwIjoiaiJ9 ) Slow CSW GetRecords requests with JDBC Configuration ( https://osgeo-org.atlassian.net/browse/GEOS-10981?atlOrigin=eyJpIjoiMDIxN2FiNTA4MmNjNGI0YmJkZmFkNGZmYmNkMDkyZjciLCJwIjoiaiJ9 ) Issue Type: Bug Affects Versions: 2.22.3, 2.23.0 Assignee: Steve Ikeoka ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Ac68be705-e740-4b23-b796-c04c7a01eaf3 ) Components: CSW, JDBCConfig Created: 16/May/23 6:31 PM Priority: Medium Reporter: Steve Ikeoka ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Ac68be705-e740-4b23-b796-c04c7a01eaf3 ) When using JDBC Configuration, CSW GetRecords requests are very slow when the request filter contains both spatial and non-spatial components even when removing the spatial part of the filter would execute very quickly. The CSW module is internally modifying the filter before passing it to the JDBC Configuration catalog in a way that prevents JDBC Configuration from being able to split the supported part of the filter into a database query so it has to load the entire catalog from the database and evaluate the filter in memory. No spatial filter would be very fast: constraint=dc:identifier='foo' Appending a spatial filter makes the request very slow: constraint=dc:identifier='foo' AND INTERSECTS(ows:BoundingBox,POINT(0 0)) ( https://osgeo-org.atlassian.net/browse/GEOS-10981#add-comment?atlOrigin=eyJpIjoiMDIxN2FiNTA4MmNjNGI0YmJkZmFkNGZmYmNkMDkyZjciLCJwIjoiaiJ9 ) Add Comment ( https://osgeo-org.atlassian.net/browse/GEOS-10981#add-comment?atlOrigin=eyJpIjoiMDIxN2FiNTA4MmNjNGI0YmJkZmFkNGZmYmNkMDkyZjciLCJwIjoiaiJ9 ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100225- sha1:6805d32 )
_______________________________________________ Geoserver-devel mailing list Geoserver-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-devel
