Nuno Oliveira ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A045c74f7-38ab-4dfa-af2b-2d9e961e7a48 ) *created* an issue
GeoServer ( https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiYTQ5ZjQ0OWViOGMyNDZmZTkxZmViZTAyNjU4NzJmYzciLCJwIjoiaiJ9 ) / Bug ( https://osgeo-org.atlassian.net/browse/GEOS-10108?atlOrigin=eyJpIjoiYTQ5ZjQ0OWViOGMyNDZmZTkxZmViZTAyNjU4NzJmYzciLCJwIjoiaiJ9 ) GEOS-10108 ( https://osgeo-org.atlassian.net/browse/GEOS-10108?atlOrigin=eyJpIjoiYTQ5ZjQ0OWViOGMyNDZmZTkxZmViZTAyNjU4NzJmYzciLCJwIjoiaiJ9 ) App-Schema issues an extra distinct count ( https://osgeo-org.atlassian.net/browse/GEOS-10108?atlOrigin=eyJpIjoiYTQ5ZjQ0OWViOGMyNDZmZTkxZmViZTAyNjU4NzJmYzciLCJwIjoiaiJ9 ) Issue Type: Bug Assignee: Unassigned Components: Application schema Created: 12/Jun/21 12:16 PM Priority: Medium Reporter: Nuno Oliveira ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A045c74f7-38ab-4dfa-af2b-2d9e961e7a48 ) Mailing list discussion thread: [Geoserver-users] App-schema - long WFS GetFeature response times without BBOX Even with the count for WFS disabled App-Schema is sending a distinct count request to the database: SELECT COUNT ( DISTINCT " schema_name ". " table_name ". "primary_key_attribute" ) FROM " schema_name ". " table_name " This request can be quite expensive to execute and it is not clear why this request is sent, this happen with a PostgreSQL database. ( https://osgeo-org.atlassian.net/browse/GEOS-10108#add-comment?atlOrigin=eyJpIjoiYTQ5ZjQ0OWViOGMyNDZmZTkxZmViZTAyNjU4NzJmYzciLCJwIjoiaiJ9 ) Add Comment ( https://osgeo-org.atlassian.net/browse/GEOS-10108#add-comment?atlOrigin=eyJpIjoiYTQ5ZjQ0OWViOGMyNDZmZTkxZmViZTAyNjU4NzJmYzciLCJwIjoiaiJ9 ) 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#100166- sha1:25236ce )
_______________________________________________ Geoserver-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-devel
