Query Widget Performance Issue

[KafilBaig]

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.

[RobertScheitlin__GISP]

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

[KafilBaig]

Hi Robert,

The map service is in non internet connection server.

Sent from my iPhone

[RobertScheitlin__GISP]

Hard to say what's wrong then.

[KafilBaig]

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

Sent from my iPhone

[RobertScheitlin__GISP]

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.

[KafilBaig]

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

[RobertScheitlin__GISP]

Those are good.

[KafilBaig]

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

[RobertScheitlin__GISP]

Sorry I am not an Oracle guy.