Tiago Vieira (
https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=5bb2534d1767377761ba6938
) *created* an issue
GeoServer (
https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiNDAwYmExYzdjMDEyNGI4MTliMTE4MTBmZTkyOTRkZGIiLCJwIjoiaiJ9
) / Improvement (
https://osgeo-org.atlassian.net/browse/GEOS-10085?atlOrigin=eyJpIjoiNDAwYmExYzdjMDEyNGI4MTliMTE4MTBmZTkyOTRkZGIiLCJwIjoiaiJ9
) GEOS-10085 (
https://osgeo-org.atlassian.net/browse/GEOS-10085?atlOrigin=eyJpIjoiNDAwYmExYzdjMDEyNGI4MTliMTE4MTBmZTkyOTRkZGIiLCJwIjoiaiJ9
) WFS - disable count of features (
https://osgeo-org.atlassian.net/browse/GEOS-10085?atlOrigin=eyJpIjoiNDAwYmExYzdjMDEyNGI4MTliMTE4MTBmZTkyOTRkZGIiLCJwIjoiaiJ9
)
Issue Type: Improvement Affects Versions: 2.18.1 Assignee: Unassigned Created:
30/May/21 7:22 PM Priority: Medium Reporter: Tiago Vieira (
https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=5bb2534d1767377761ba6938
)
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?
(
https://osgeo-org.atlassian.net/browse/GEOS-10085#add-comment?atlOrigin=eyJpIjoiNDAwYmExYzdjMDEyNGI4MTliMTE4MTBmZTkyOTRkZGIiLCJwIjoiaiJ9
) Add Comment (
https://osgeo-org.atlassian.net/browse/GEOS-10085#add-comment?atlOrigin=eyJpIjoiNDAwYmExYzdjMDEyNGI4MTliMTE4MTBmZTkyOTRkZGIiLCJwIjoiaiJ9
)
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#100165-
sha1:3611a76 )
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
