topic Re: Query Widget Performance Issue in ArcGIS Web AppBuilder Questions

Query Widget Performance Issue

KafilBaig — Thu, 16 May 2019 09:48:40 GMT

We have a requirement for search with owner name in the query widget. For this to achive we have done the following steps.

1)We have a geodatabase created in oracle 12c. Created a table with point feature class which has fields with names. Added indexes for the attributes in geodatabase.

2)Created a map document added the layer in that from geodatabase table.

3)Published as map service.

In query widget accessed the map service and doing the query for owner name.

Just to query for 23records it took more than 50 seconds. How can we improve the performance of the query to fetch more records.

Re: Query Widget Performance Issue

RobertScheitlin__GISP — Thu, 16 May 2019 13:30:21 GMT

Can you provide the URL to the map service for me to check?

Re: Query Widget Performance Issue

KafilBaig — Thu, 16 May 2019 14:15:57 GMT

Hi Robert,

The map service is in non internet connection server.

Sent from my iPhone

Re: Query Widget Performance Issue

RobertScheitlin__GISP — Thu, 16 May 2019 14:27:08 GMT

Hard to say what's wrong then.

Re: Query Widget Performance Issue

KafilBaig — Thu, 16 May 2019 16:22:33 GMT

I can send u the snapshot of service . Is that ok ?

Sent from my iPhone

Re: Query Widget Performance Issue

RobertScheitlin__GISP — Thu, 16 May 2019 18:01:26 GMT

Sorry, no that will not help. I was wanting to test your service to see if I could diagnose the issue. Basically you have some issue with your service because I have map services with 100s of thousands of records and it does not take more than a few seconds to return results.

Re: Query Widget Performance Issue

KafilBaig — Fri, 17 May 2019 11:43:00 GMT

Just wanted to make sure if am missing anything when creating the service which is affecting the performance .

I have followed the below steps to create a map service .

1) create a mxd file and add the layer from geodatabase feature layer . From catalog window through database connection I drag the feature layer to mxd document.

2) analyze and share as service

I am not changing any of the values and just keeping it default .

In query widget adding a new query and accessing the service url .

Please let me know if am following the correct procedures.

Sent from my iPhone

Re: Query Widget Performance Issue

RobertScheitlin__GISP — Fri, 17 May 2019 12:44:21 GMT

Those are good.

Re: Query Widget Performance Issue

KafilBaig — Fri, 17 May 2019 13:18:25 GMT

I just noticed that geometry index is for st_geometry and srid 4326

Whereas our feature class table has a column shape which has the data as sdo_geometry . Will this affect the performance .

Sent from my iPhone

Re: Query Widget Performance Issue

RobertScheitlin__GISP — Fri, 17 May 2019 13:21:58 GMT

Sorry I am not an Oracle guy.