[Geoserver-devel] [JIRA] (GEOS-10108) App-Schema issues an extra distinct count

Nuno Oliveira created an issue

GeoServer / BugGEOS-10108

App-Schema issues an extra distinct count

Issue Type:

BugBug

Assignee:

Unassigned

Components:

Application schema

Created:

12/Jun/21 12:16 PM

Priority:

MediumMedium

Reporter:

Nuno Oliveira

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.

Add Comment

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS


This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100166-sha1:25236ce)

Atlassian logo