I have been requested to create a geoprocessing service that returns attributes from 10 different (and somewhat complex) polygon layers with the input being a lat/long. I'm pretty new to this area of ArcGIS so sorry if this is a bit of a ramble.
The only way I know how to do that is by creating a python script that will be run start to finish each time, then share this as a geoprocessing service. The current script does this.
1. Creates a feature layer for each polygon dataset
2. Does a select by location on each of these polygon layers
3. Does a search cursor for each of the polygon layers
4. Return the results
This process works, but is on the slow side ~4seconds. We would like to get it under 1 second if possible. Most of the time appears to be in creating the feature layer, so I was wondering if it is possible to create a service that has those already created then just needs to do the search by location part. Or to create a script that constantly runs and waits for a call before returning results.
Thanks for any pointers.