topic Re: Big difference between REST and Geoprocessor query performance in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/big-difference-between-rest-and-geoprocessor-query/m-p/169609#M6745 <HTML><HEAD></HEAD><BODY><SPAN>it is not exactly the same thing: </SPAN><BR /><SPAN>1) One drawback of geoprocessing services is that they have a relatively large memory footprint and may run slower.</SPAN><BR /><SPAN>2) Select by attributes stores the selection so if you have many rows in result of query, the result is stored in a table</SPAN></BODY></HTML> Thu, 19 Jun 2014 10:20:39 GMT nicogis 2014-06-19T10:20:39Z Big difference between REST and Geoprocessor query performance https://community.esri.com/t5/arcgis-enterprise-questions/big-difference-between-rest-and-geoprocessor-query/m-p/169608#M6744 <HTML><HEAD></HEAD><BODY><SPAN>I've written an application for bench marking and tracking performance of ArcGIS Server. As part of the app it does a Javascript API Query Task of a feature layer though the REST and later runs the Select By Attribute GP tool from a Geoprocessing Task. This is the same SDE feature class with about 1.34 million polygons, it has both spatial and attribute indexes in place. The query runs in about 1 second from the REST but takes 1 1/2 minutes from the GP Tool. What is up with that?</SPAN><BR /><BR /><SPAN>The SDE feature class is in PostgreSQL SDE 10.2.2</SPAN><BR /><SPAN>ArcGIS Server 10.2.2</SPAN><BR /><SPAN>Windows 2008 r2</SPAN><BR /><BR /><SPAN>The definition query and rendering performance is great! GP is really slow!</SPAN><BR /><BR /><SPAN>Dave</SPAN></BODY></HTML> Tue, 17 Jun 2014 18:36:40 GMT https://community.esri.com/t5/arcgis-enterprise-questions/big-difference-between-rest-and-geoprocessor-query/m-p/169608#M6744 DaveHighness 2014-06-17T18:36:40Z Re: Big difference between REST and Geoprocessor query performance https://community.esri.com/t5/arcgis-enterprise-questions/big-difference-between-rest-and-geoprocessor-query/m-p/169609#M6745 <HTML><HEAD></HEAD><BODY><SPAN>it is not exactly the same thing: </SPAN><BR /><SPAN>1) One drawback of geoprocessing services is that they have a relatively large memory footprint and may run slower.</SPAN><BR /><SPAN>2) Select by attributes stores the selection so if you have many rows in result of query, the result is stored in a table</SPAN></BODY></HTML> Thu, 19 Jun 2014 10:20:39 GMT https://community.esri.com/t5/arcgis-enterprise-questions/big-difference-between-rest-and-geoprocessor-query/m-p/169609#M6745 nicogis 2014-06-19T10:20:39Z