Does a definition query effect the hosted feature layer performance?

JoeSaltenberger — Wed, 24 Feb 2021 21:19:34 GMT

If I have a layer in ArcMap/Pro with a definition query applied to it and I publish as a hosted feature service, will that hosted feature service perform as well compared to if I exported the subset to another feature class and published?

Even though the definition query is still applied in the hosted feature service, all the data is uploaded to AGOL, which I was thinking may have an impact on the speed that the service can process and return results from query or edit operations.

Thanks.

Re: Does a definition query effect the hosted feature layer performance?

JayantaPoddar — Wed, 24 Feb 2021 21:38:22 GMT

One can expect the subset layer to render/query faster than the layer with definition query (the difference could be negligible for smaller datasets), just for the fact that the latter has to run the definition query on-the-fly.

But again, it depends on your requirement. You must have a reason to go with a definition-queried layer.

topic Does a definition query effect the hosted feature layer performance? in ArcGIS Online Questions

Does a definition query effect the hosted feature layer performance?

Re: Does a definition query effect the hosted feature layer performance?