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

_Failed_to_Retrieve · May 30, 2021, 5:22pm

Tiago Vieira created an issue

Issue Type:	Improvement
Affects Versions:	2.18.1
Assignee:	Unassigned
Created:	30/May/21 7:22 PM
Priority:	Medium
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 &lt;= 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 &lt;= 100000

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

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)