topic Bad count-only query performance on layer with 600'000 polygons in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/bad-count-only-query-performance-on-layer-with-600/m-p/16290#M603 <HTML><HEAD></HEAD><BODY><P>One of our layers contains approximately 600'000 polygons that should be displayed as a featurelayer in our application based on the 4.4 JSAPI.</P><P></P><P>Strangely, since the 4.3 version of the API, a count-only request to the map service is performed before it starts loading the features. It occured to me that the performance of this count-only query is very bad! It takes around 50 seconds just &nbsp;to return the amount of records within that layer.</P><P></P><P>Further analysis with an SQL profiler has shown that a count-only query seems to be implemented in a strange way such that it translates to the following oracle / sql query:</P><P></P><P>select ID, spatialdata from (SQL_QUERY DEFINED IN THE MAP SERVICE / LAYER)</P><P></P><P>I would have expected a "select count()" here, but instead, it simply selects the ID and spatial field on the query defined in the map service, and probably counts the returned records manually. As a result, before we can&nbsp;load the layer, we have to wait 50 seconds just to wait for this count-query to finish.</P><P></P><P>Am I the only one with this problem? Is this a known bug? Is there any workaround?</P></BODY></HTML> Mon, 04 Sep 2017 09:19:07 GMT KevinHaeni 2017-09-04T09:19:07Z Bad count-only query performance on layer with 600'000 polygons https://community.esri.com/t5/arcgis-enterprise-questions/bad-count-only-query-performance-on-layer-with-600/m-p/16290#M603 <HTML><HEAD></HEAD><BODY><P>One of our layers contains approximately 600'000 polygons that should be displayed as a featurelayer in our application based on the 4.4 JSAPI.</P><P></P><P>Strangely, since the 4.3 version of the API, a count-only request to the map service is performed before it starts loading the features. It occured to me that the performance of this count-only query is very bad! It takes around 50 seconds just &nbsp;to return the amount of records within that layer.</P><P></P><P>Further analysis with an SQL profiler has shown that a count-only query seems to be implemented in a strange way such that it translates to the following oracle / sql query:</P><P></P><P>select ID, spatialdata from (SQL_QUERY DEFINED IN THE MAP SERVICE / LAYER)</P><P></P><P>I would have expected a "select count()" here, but instead, it simply selects the ID and spatial field on the query defined in the map service, and probably counts the returned records manually. As a result, before we can&nbsp;load the layer, we have to wait 50 seconds just to wait for this count-query to finish.</P><P></P><P>Am I the only one with this problem? Is this a known bug? Is there any workaround?</P></BODY></HTML> Mon, 04 Sep 2017 09:19:07 GMT https://community.esri.com/t5/arcgis-enterprise-questions/bad-count-only-query-performance-on-layer-with-600/m-p/16290#M603 KevinHaeni 2017-09-04T09:19:07Z Re: Bad count-only query performance on layer with 600'000 polygons https://community.esri.com/t5/arcgis-enterprise-questions/bad-count-only-query-performance-on-layer-with-600/m-p/16291#M604 <HTML><HEAD></HEAD><BODY><P>Kevin, I converted this from a discussion to a question. Also, tagging <A href="https://community.esri.com/community/developers/web-developers/arcgis-api-for-javascript?sr=search&amp;searchId=4f268e26-efe7-49b9-94b5-bd4c8d3f720d&amp;searchIndex=1">https://community.esri.com/community/developers/web-developers/arcgis-api-for-javascript?sr=search&amp;searchId=4f268e26-efe7-49b9-94b5-bd4c8d3f720d&amp;searchIndex=1</A>‌ for more exposure.</P><P></P><P>it may help to know what version of ArcGIS Server you are using, and if you recently upgraded, from what to what?</P></BODY></HTML> Mon, 04 Sep 2017 18:44:13 GMT https://community.esri.com/t5/arcgis-enterprise-questions/bad-count-only-query-performance-on-layer-with-600/m-p/16291#M604 RebeccaStrauch__GISP 2017-09-04T18:44:13Z Re: Bad count-only query performance on layer with 600'000 polygons https://community.esri.com/t5/arcgis-enterprise-questions/bad-count-only-query-performance-on-layer-with-600/m-p/16292#M605 <HTML><HEAD></HEAD><BODY><P>Hi Rebecca</P><P>Thank you! It seems we have version 10.4.1 installed!</P></BODY></HTML> Tue, 05 Sep 2017 06:21:13 GMT https://community.esri.com/t5/arcgis-enterprise-questions/bad-count-only-query-performance-on-layer-with-600/m-p/16292#M605 KevinHaeni 2017-09-05T06:21:13Z Re: Bad count-only query performance on layer with 600'000 polygons https://community.esri.com/t5/arcgis-enterprise-questions/bad-count-only-query-performance-on-layer-with-600/m-p/16293#M606 <HTML><HEAD></HEAD><BODY><P>Ah and we haven't upgraded the server so far.</P></BODY></HTML> Tue, 05 Sep 2017 06:22:01 GMT https://community.esri.com/t5/arcgis-enterprise-questions/bad-count-only-query-performance-on-layer-with-600/m-p/16293#M606 KevinHaeni 2017-09-05T06:22:01Z