Hello,

A question:

Having an EDBSERVER running in a windows server 2016.

1st approach:
all the sessions, running from the same server, as local session. (same config path)
the session running in other workstation in the network as remote session.

2nd approach:
all the sessions, included the ones in the same server running as remotes sessions?

Thanks for your advice.

Jorge


I'd make them all remote. A mix of local and remote is possible but you'll loose the advantages of going c/s by doing that. I'm not sure how things are now but it used to be the case that Windows would alter the locking when more than one process was accessing files. I think the server counts as one adding a single local user bumps it to two which will slow things down. After the first additional user the performance should depend on the load.

Without knowing details of your system but remembering you're talking very large tables you may find local usage will swamp the LAN.

Roy Lambert

On 9/4/2018 2:29 AM, Roy Lambert wrote:
> I'd make them all remote.

+1

As Roy said without knowing more about what the software does it's hard
to come up with recommendation.

However, my view is that unless there is some specific reason for going
with local i'd do C/S. This is especially true if most of your installs
would need to run some C/S mode anyway.

Raul

Jorge,

Addint to what others said, also keep in kind that if you mix local and remote acess you can't use the new "Global file I/O buffering" feature.

--
Fernando Dias
[Team Elevate]

Jorge,

<< all the sessions, included the ones in the same server running as remotes sessions? >>

Use this second approach.  As Fernando indicates, you can't share databases with the new global file I/O buffering in 2.28, and you're going to want to use that, due to the performance gains that can be achieved.

Tim Young
Elevate Software
www.elevatesoft.com