Hi again,

I'm still trying to get better C/S performance, and stumbled over something:

My app can be started in C/S-mode, and, if the DB server is down, can use the shared
folder access instead. So I set the database path in the config file to
"\\server\share\database" - this way it can be accessed via both ways.

Now I altered the database path to a local path for the server (e.g. "D:\share\database").
This way the database cannot be accessed anymore by a local session, BUT when using C/S, I
got a huge performance boost.

Any chance of getting the better performance, and the possibility to connect a local and
remote session to the same database ?

Heiko

Heiko,

<< Now I altered the database path to a local path for the server (e.g.
"D:\share\database"). This way the database cannot be accessed anymore by a
local session, BUT when using C/S, I got a huge performance boost.

Any chance of getting the better performance, and the possibility to
connect a local and remote session to the same database ? >>

Unfortunately this is a function of the OS and how it deals with UNC path
names.  What OS are you using for the ElevateDB Server ?  It might be a bug
in the OS.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

>>What OS are you using for the ElevateDB Server ?

Tried it with XP Pro, maybe on W2K3 Server it is different.

Just a thought : Would it be possible to use 2 different configuration files ? Could this
lead to problems with mixed (local and remote) sessions ?

Heiko

Heiko,

<< Tried it with XP Pro, maybe on W2K3 Server it is different. >>

Is your XP using SP2 ?

<< Just a thought : Would it be possible to use 2 different configuration
files ? Could this lead to problems with mixed (local and remote) sessions ?
>>

No, that will lead to problems.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


What about 1 configuration file 2 databases 1 with the UNC path, 1 with the local path?

Roy Lambert

Tim


I thought Windows (XP onwards anyway) resolved the UNC path to a local path if it could. I remember some major problems getting XP to accept UNC paths in shortcuts

Roy Lambert

Roy,

<< What about 1 configuration file 2 databases 1 with the UNC path, 1 with
the local path? >>

It won't work since they'll be using two different internal locking slots
for the same database.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< I thought Windows (XP onwards anyway) resolved the UNC path to a local
path if it could. I remember some major problems getting XP to accept UNC
paths in shortcuts >>

Yes, but XP SP1 had an issue with slowdowns with UNC path names.

--
Tim Young
Elevate Software
www.elevatesoft.com