Query Widget Performance Issue

148
9
05-16-2019 02:48 AM
KafilBaig
New Contributor III

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.

0 Kudos
9 Replies
RobertScheitlin__GISP
MVP Esteemed Contributor

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

0 Kudos
KafilBaig
New Contributor III

Hi Robert,

The map service is in non internet connection server.

Sent from my iPhone

0 Kudos
RobertScheitlin__GISP
MVP Esteemed Contributor

Hard to say what's wrong then.

0 Kudos
KafilBaig
New Contributor III

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

Sent from my iPhone

0 Kudos
RobertScheitlin__GISP
MVP Esteemed Contributor

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.

0 Kudos
KafilBaig
New Contributor III

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

0 Kudos
RobertScheitlin__GISP
MVP Esteemed Contributor

Those are good.

0 Kudos
KafilBaig
New Contributor III

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

0 Kudos
RobertScheitlin__GISP
MVP Esteemed Contributor

Sorry I am not an Oracle guy.

0 Kudos