Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 8 of 8 total |
Database Paths and C/S Performance |
Mon, Jul 28 2008 1:24 PM | Permanent Link |
Heiko Knuettel | 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 |
Mon, Jul 28 2008 4:33 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Mon, Jul 28 2008 4:43 PM | Permanent Link |
Heiko Knuettel | 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 |
Mon, Jul 28 2008 5:55 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Jul 29 2008 7:51 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
What about 1 configuration file 2 databases 1 with the UNC path, 1 with the local path? Roy Lambert |
Tue, Jul 29 2008 7:51 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Tue, Jul 29 2008 5:37 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Jul 29 2008 5:38 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |