[Geoserver-devel] [JIRA] (GEOS-10085) WFS - disable count of features

Tiago Vieira created an issue

GeoServer / ImprovementGEOS-10085

WFS - disable count of features

Issue Type:

ImprovementImprovement

Affects Versions:

2.18.1

Assignee:

Unassigned

Created:

30/May/21 7:22 PM

Priority:

MediumMedium

Reporter:

Tiago Vieira

Is it possible to disable the WFS Count everytime that with make a request? It does a double query, sometimes very expensive to database.

Example:
First:

2021-05-30 17:54:56,288 http-nio-3000-exec-2  DEBUG [geotools.jdbc] - SELECT count(*) AS gt_result_ FROM (SELECT * FROM (SELECT * FROM N_TST.V_GS_T_LABELS WHERE SDO_RELATE(GEOM, ?, 'mask=anyinteract querytype=WINDOW') = 'TRUE' ) WHERE ROWNUM <= 100000) gt_limited_

Then:

2021-05-30 17:54:56,350 http-nio-3000-exec-3  DEBUG [geotools.jdbc] - SELECT * FROM (SELECT ID,ELEMENT_ID,TYPE,STYLE,GEOM as GEOM,LABEL,ROTATION,POSITION FROM N_TST.V_GS_T_LABELS WHERE SDO_RELATE(GEOM, ?, 'mask=anyinteract querytype=WINDOW') = 'TRUE'  ORDER BY ID ASC) WHERE ROWNUM <= 100000

Secondly, is it possible to remove the “order by” from the request?

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#100165-sha1:3611a76)

Atlassian logo