Hello,
the webscene viewer (portal/home/webscene/viewer.html) generates queries that are very costly for our database. There queries often just and in an error or timeout and affect other queries running at the same time.
GET/server/rest/services/LoD2_2D/LoD2_2D_2024/FeatureServer/0/queryf=json&outFields=*&outStatistics=[{"maxPointCount":100000000,"maxRecordCount":100000000,"maxVertexCount":83334,"outStatisticFieldName":"exceedslimit","statisticType":"exceedslimit"}]&returnGeometry=false&spatialRel=esriSpatialRelIntersects&where=1=1
This results in this database query (SDE on ms sql server):
SELECT 1 AS exceedslimit FROM SDE.LoD2_2D_2024 HAVING (COUNT(*)>100000000 OR SUM(SHAPE.STNumPoints())>83334)
In our case there are over 50 million building footprints in this layer which the database has to read all from disk to count them and the number of points of each geometry.
How can this be avoided?
