topic Re: eSearch Widget slow return, looking for ways to speed things up. in ArcGIS Web AppBuilder Questions

eSearch Widget slow return, looking for ways to speed things up.

James_Armstrong — Tue, 17 Nov 2020 17:13:31 GMT

I am using Robert's eSearch widget in an application created through WAB-DEV. As usual, his widgets are pretty slick.

in this instance though, I am running a search against 2,528,552 parcels (from a feature service (state wide parcel set)). For this particular search, only the 3996 parcels within one town are needed. There is a definition filter at the webmap level so that only the parcels within the Town are shown. Similar, in the eSearch widget configuration, there is a definition expression that (i am assuming) limits the search only the parcels with the Town's ID code.

Town_ID = 277

The thing is, in using the eSearch, the search for either the Parcel ID or the Owner Name takes along time. Many times to what I am thinking is a time out failure. Does anyone have suggestions how this search would resolve quicker?

Re: eSearch Widget slow return, looking for ways to speed things up.

RobertScheitlin__GISP — Tue, 17 Nov 2020 17:25:09 GMT

James,

Have you tried this search in the browser just using the rest end point to see if the time needed to perform the search is just due to the speed of your service?

Re: eSearch Widget slow return, looking for ways to speed things up.

James_Armstrong — Tue, 17 Nov 2020 23:57:54 GMT

Robert,

Ok, I realize I am being a bit dense here. Im not sure what you mean by:

Have you tried this search in the browser just using the rest end point to see if the time needed to perform the search is just due to the speed of your service?

Would you expand on you previous responds? I have included the urls associated with the data set.

Re: eSearch Widget slow return, looking for ways to speed things up.

RobertScheitlin__GISP — Wed, 18 Nov 2020 13:54:12 GMT

James,

So what happen in the background of the eSearch is a query task is executed on the REST service. You can manually query a service by clicking on the query operation link at the bottom of your REST service page.

When I execute this query

https://services1.arcgis.com/hGdibHYSPO59RG1h/ArcGIS/rest/services/L3_TAXPAR_POLY_ASSESS_gdb/FeatureServer/0/query?where=Town_ID+%3D+277+AND+OWNER1+LIKE+%27%25smith%25%27&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&resultType=none&distance=0.0&units=esriSRUnit_Meter&returnGeodetic=false&outFields=*&returnGeometry=true&returnCentroid=false&featureEncoding=esriDefault&multipatchOption=xyFootprint&maxAllowableOffset=&geometryPrecision=&outSR=102100&datumTransformation=&applyVCSProjection=false&returnIdsOnly=false&returnUniqueIdsOnly=false&returnCountOnly=false&returnExtentOnly=false&returnQueryGeometry=false&returnDistinctValues=false&cacheHint=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&having=&resultOffset=&resultRecordCount=&returnZ=false&returnM=false&returnExceededLimitFeatures=true&quantizationParameters=&sqlFormat=none&f=pjson&token=

Which is a simple query using Town_ID = 277 AND OWNER1 LIKE '%smith%' it takes approximately 99 seconds to execute. 2,528,552 records is just a very large dataset to query.

One way you could speed this up is to have a nightly (or some scheduled) routine to make a separate service for the county of interest.