Slow Search Performance on Data in File Geodatabase

[AlanToms]

Hello Folks,

We are running into a search performance issue.  I have read previously that a file geodatabase has better performance than data stored in SDE; though I can???t seem to find the Help page at the moment.   Ok so we setup our services to read from a file geodatabase and the drawing performance does seem to be faster than SDE. 

We run into a problem with a web app that is doing a parcel search.  There is a text box that a user enters the parcel number then clicks the search button.  If the parcel service is pointed at the file geodatabase it takes 13+ seconds to return results.  If the parcel service is pointed at SDE it takes about 1-2 seconds.  It is the exact same data and the field we are searching on is indexed.

Any suggestions?

Thank you
Alan

[nicogis · Accepted solution]

this is the help page http://resources.arcgis.com/en/help/main/10.1/0154/015400000325000000.htm

Is file GDB local or another position? One thing on the performance difference is: network traffic & network I/O capacity, between the client machine and the server.

[AlanToms]

this is the help page http://resources.arcgis.com/en/help/main/10.1/0154/015400000325000000.htm

Is file GDB local or another position? One thing on the performance difference is: network traffic & network I/O capacity, between the client machine and the server.

I thought it was local, but come to find out it was referencing the local data with a UNC path.  Once I fixed that, it is working as expected.

Thank you
Alan