topic Re: How to reduced query result limit..? in ArcGIS JavaScript Maps SDK Questions

How to reduced query result limit..?

Rocky_ — Mon, 06 Aug 2018 17:02:52 GMT

I am trying to query feature from service url. which having set MaxRecordCount: 100000 ..

is there any possible way to reduced the limit for query results, cause this MaxRecordCount: 100000 giving me error of Timeout exceeded and Error performing query operation.

Can anyone please tell me how to solve this issue.

Thanks in advance..

Re: How to reduced query result limit..?

JohnGrayson — Mon, 06 Aug 2018 17:20:11 GMT

You can try using the 'start' and 'num' parameters to break up the queries into manageable numbers (Query | API Reference | ArcGIS API for JavaScript 4.8) Providing a decent UX for >100,000 features can be tricky so might think about filtering the data as part or your query, or providing a some type of 'paging' UI.

Re: How to reduced query result limit..?

RobertScheitlin__GISP — Mon, 06 Aug 2018 17:24:27 GMT

RAJ,

You can set the esriConfig request timeout property.

https://developers.arcgis.com/javascript/latest/api-reference/esri-config.html#request

Re: How to reduced query result limit..?

Rocky_ — Mon, 06 Aug 2018 17:30:37 GMT

Hi Robert,

can you please share a snippet, how to use this timeout property..?

Re: How to reduced query result limit..?

Rocky_ — Mon, 06 Aug 2018 17:32:23 GMT

Hello john,

Can you please share me a snippet or sample for it..

Re: How to reduced query result limit..?

RobertScheitlin__GISP — Fri, 10 Dec 2021 21:28:18 GMT

require(["esri/config"], function(esriConfig) {
  esriConfig.request.timeout = 120000;
});‍‍‍

This will affect all queries made in that app.

Re: How to reduced query result limit..?

Rocky_ — Mon, 06 Aug 2018 17:44:15 GMT

Tried this one, but not working.. still got same error timeout exceeded...

Re: How to reduced query result limit..?

RobertScheitlin__GISP — Mon, 06 Aug 2018 17:51:15 GMT

RAJ,

Then it could be that 2 minutes is still not long enough and you are getting into the seriously unacceptable user wait time.

Re: How to reduced query result limit..?

Rocky_ — Mon, 06 Aug 2018 17:54:28 GMT

so what is the possible solution for this..? can we reduced the result count to certain limit.. such as

max 5000 count per query

Re: How to reduced query result limit..?

RobertScheitlin__GISP — Mon, 06 Aug 2018 17:57:34 GMT

Sure that is controlled at the map service level. Go to server manager and adjust the maxRecordCount property

Re: How to reduced query result limit..?

Rocky_ — Mon, 06 Aug 2018 18:13:29 GMT

I cant change the property on service itself. Is it any other way to do it..within the script..??

Re: How to reduced query result limit..?

JohnGrayson — Mon, 06 Aug 2018 18:18:00 GMT

Hello Raj,

can you please provide a simplified version of the specific portion of your code as a working codepen, jsbin, or similar, so we can see what you're trying?

Re: How to reduced query result limit..?

RobertScheitlin__GISP — Mon, 06 Aug 2018 18:18:00 GMT

Not that I am aware of

Re: How to reduced query result limit..?

Rocky_ — Mon, 06 Aug 2018 18:21:37 GMT

No worries.. Thanks for help.. Really appreciate that..

Re: How to reduced query result limit..?

HezronPhilip — Tue, 07 Aug 2018 04:06:18 GMT

Hi,

I'd suggest an alternative: First attempt to query for Object IDs (QueryTask | API Reference | ArcGIS API for JavaScript 3.25 ) and check how many features you are getting in the response. Using the object IDs in the response, you can query about half of the Object IDs to retrieve the features to test your response time. If it is still too long, you can again split it in half. Splitting your queries can reduce response time from the server.

Re: How to reduced query result limit..?

Rocky_ — Tue, 07 Aug 2018 14:15:41 GMT

Thanks for information. I'll try this one..

Re: How to reduced query result limit..?

HezronPhilip — Wed, 08 Aug 2018 04:46:39 GMT

Hi Raj,

I would also suggest that when returning such a huge number of features, do not return geometry. (Although that would depend on what you are trying to attempt with the query)

set returnGeometry = false to get better response times in your query while attempting to query large number of features and then retrieve geometry on selection from a list of the returned features maybe.

Re: How to reduced query result limit..?

Rocky_ — Wed, 08 Aug 2018 13:59:17 GMT

Thanks for the suggestion Philip. I'll try this solution.. lets see how it works..