topic Re: Accessing file-gdb over network not advisable, why? in Data Management Questions

Accessing file-gdb over network not advisable, why?

mattwilkie — Wed, 25 Jun 2014 20:56:17 GMT

In another thread the formidable Vince Angelo was seen saying "It's best practice to not access FGBDs over a network link". Would someone in the know please expand on that? What makes it not best practice?

I'm most interested in read-by-many users and write-by-one (or few) scenario but please feel free to go beyond that. Thanks.

Re: Accessing file-gdb over network not advisable, why?

Anonymous User — Thu, 26 Jun 2014 02:29:31 GMT

File Geodatabases are frustrating for multiuser/enterprise environments. I believe Vince was replying to that user's specific situation, which included an interest in refreshing data which could be actively in use. If someone is connected to the fgdb when you wish to modify it, you're out of luck unless you're ok with bouncing the server. So in this context, an enterprise SDE geodatabase is preferable, as you can identify locks and take advantage of versioning and replication.

There may be more to it, but I suspect it is logistics, rather than network limitations, which inform this advice.

Re: Accessing file-gdb over network not advisable, why?

VinceAngelo — Thu, 26 Jun 2014 10:13:16 GMT

It's not so much "network limitations" as it is "Microsoft networking" which is the
major determinate. For some reason never adequately explained, a perfectly
reasonable set of read() operations across multiple files, when executed across
a network on a Windows operating system, becomes a major performance snarl.
I don't have the time to do a benchmark right now to give hard numbers, but the
same performance difference does not generally exist over NFS between two
Unix nodes. Read/write operations are also significantly affected, and multi-user
read/write, with it's attendant locking issues, just makes it worse.

- V

Re: Accessing file-gdb over network not advisable, why?

mattwilkie — Thu, 26 Jun 2014 19:07:20 GMT

So Vince if I read your comment correctly, multi-user file-gdb performance between two 'nix machines over NFS should operate close to optimal, but anything involving Windows will have problems? (including 'nix and Samba/CIFS?) ...which pretty much means anything involving Arcmap is trouble. Can you put a number on how many ArcGIS Desktop clients are involved when Microsoft networking starts becoming problematic?

The background for my question is that we've been using a file-gdb central store for our department for sometime and are contemplating moving to an RDBMS store, primarily to take advantage of gdb replication to district offices, secondarily for true topology etc. We've also been experiencing decaying performance issues over a number of months and are wondering if multi-user file-gdb is at root. Staying with a file-gdb store is attractive because we don't have any dedicated SysAdmins or DBA's around to build, tune and maintain an RDBMS, but in the end performance could be the deciding factor. (So cross our fingers and hope a spousal "yes dear" install of ArcGIS Server and Postgres is enough.)

Centrally we have 6 to 10 active daily use ArcGIS Desktop users, 2 to 3 data editors (but this happens rarely, once a week perhaps), 25-50 readers, currently using ArcReader but looking to migrate to web maps (served from a local ArcGIS server).

thanks in advance for your thoughts.

Re: Accessing file-gdb over network not advisable, why?

VinceAngelo — Thu, 26 Jun 2014 20:17:45 GMT

Can you put a number on how many ArcGIS Desktop clients are involved when Microsoft networking starts becoming problematic?

One, unfortunately, which is why it's not recommended.

Once you have an AGS seat, you should really evaluate database technologies. Yes, running
one is expensive (even free databases need administration), but so is having two dozen people
waiting on a file geodatabase.

- V