nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Location of a SDE file

RiccardoKlinger

I am running an enterprise geodatabase and conenct to this from ArcMAP using a SDE file.

My questions: Is the location of the SDE file of relevance? Is it only read for a single session once to connect to the database or is it read multiple times during a session with ArcMAP? Currently the SDE file is not stored on the local drive...

Looking forward your replies.

Best, Riccardo

Find more posts tagged with

Database Access

Enterprise geodatabase

Databases

Accepted answers

George_Thompson

I have not heard of any performance issues if the .sde file is on a network share.

Once you make a connection and bring in the feature class, the workflow above related to pan/zoom is correct and the client handles it.

Are you having issue with an .sde file on a network share?

All comments

George_Thompson

I would say the location is important to the people who need to have access to it.

The .sde file includes all the information to connect to that specific Enterprise Geodatabase. I have seen where organizations will have the .sde files on a network share that specific users can access.

As far as I know, you can access the same .sde file as many times as needed or concurrently while on a network drive.

The ArcGIS client (Pro, Server, ArcMap, etc.) may make multiple connections to the Enterprise Geodatabase in a single session based on the need and what is being requested.

Hopefully that adds some clarity. Let us know if you have any other questions. Thanks!

RiccardoKlinger

Hi @George_Thompson , I am aware, that many users can use the same SDE file. My main question is, whether we are facing some performance issues in using a SDE file that resides on a network share.

If the SDE file is only read once and then every pan and zoom (and therefore every request to the DB) is handled by the client itself this will not be a big deal. If the client always uses/reads the SDE file for every query towards the DB, than the additional communication to the network share will add some little latency and the overall performance of a layer in arcmap might be affected.

So: will we gain some performance in placing a SDE file on the C-drive or no...

George_Thompson

I have not heard of any performance issues if the .sde file is on a network share.

Once you make a connection and bring in the feature class, the workflow above related to pan/zoom is correct and the client handles it.

Are you having issue with an .sde file on a network share?

RiccardoKlinger

NO, they are working technically correct. We are just experiencing very slow performance of our ArcMAP under Win10 and I am trying to find problem candidates.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.