topic Slow Search Performance on Data in File Geodatabase in ArcGIS Enterprise Questions

Slow Search Performance on Data in File Geodatabase

AlanToms — Mon, 15 Oct 2012 12:25:36 GMT

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

Re: Slow Search Performance on Data in File Geodatabase

nicogis — Tue, 16 Oct 2012 15:30:39 GMT

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.

Re: Slow Search Performance on Data in File Geodatabase

AlanToms — Thu, 18 Oct 2012 12:29:39 GMT

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