Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #9942

Re: Slow performance with >1 user on server

Path csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From "Wolfgang Riedmann" <wriedmann@gmail.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Slow performance with >1 user on server
Date Sun, 13 Nov 2016 10:41:29 +0100
Lines 74
Message-ID <e8qqqaFksf8U1@mid.individual.net> (permalink)
References <7br82c1mvbg0s6isv68j324k9er2nqahg0@4ax.com> <o07shg$hs0$1@news.albasani.net>
Mime-Version 1.0
Content-Type text/plain; charset=iso-8859-1
X-Trace individual.net ZQ//feedJQQGsBqFqh717wKrY26qiAZWVWmCuBudqUBB6Dwfs=
Cancel-Lock sha1:X03UT3W0BMm7XIR3IyOgcmcpZP4=
User-Agent XanaNews/1.18.1.6
Xref csiph.com comp.lang.clipper.visual-objects:9942

Show key headers only | View raw


Hi Dick,

if you have performance issues, the best thing you can do is to switch
to ADS.

Another solution I have implemented is to switch to SSD drives in the
server and making sure that the clients have at least 1 GB cabled
connections to the server. But of course the performance gain is not so
good as with ADS.

Wolfgang


Jamal wrote:

> Dick,
> 
> Does the following link make sense?
> 
> http://www.apollodb.com/using_engine_network.asp
> 
> Quoting from above link (just in case it is no longer available):
> 
> The crux of the problem is that even after the 2nd user closes his
> connection to the database, and the first user is back to being the
> only user working on the database, this first users's Windows
> workstation does not resume exclusive mode file access until the file
> (i.e. database) is closed and re-opened. This is the reason why all
> desktop applications running in this type of "file server" mode
> suffer from poor multi-user performance and why database applications
> especially experience data corruption and various other locking
> problems. Any long time Jet/Access developer will recognize this
> scenario.
> 
> The article goes on and recommends Apollo Server which utilizes
> TCP/IP via SQL commands. ADS is another alternative.
> 
> If you stick to your current setup, you really cannot do that much
> about the speed. However, an EXE at each workstation would help
> somewhat.
> 
> Ultimately, the best solution is to move to SQL.
> 
> Jamal
> 
> "D.J.W. van Kooten"  wrote in message
> news:7br82c1mvbg0s6isv68j324k9er2nqahg0@4ax.com...
> 
> One of our program is installed on a server where it used by 3 users
> or less. They noticed that the program is very fast - until a 2nd/3rd
> user starts working with it at the same time. Then just changing a
> value, e.g. via a bBrowser, or looking up data can take so long
> (saying the useal 'the program is not responding') that they break the
> program a few times an hour and restart.
> 
> The program doesn't do anything real different from what we installed
> for years and which doesn't give that problem. We tried using the data
> via ADS (local server) and DBFCDX which does not make a difference. I
> think a virusscanner couldn't cause it (I asked their IT department to
> check that but they are very slow to respond) because that would slow
> down one user as well.
> 
> Server I don't know but I expect something like Windows Server,
> probably 2008 and PC's are Windows 7. It's in a corporate environment
> with lots of restrictions.
> 
> Is there anything I have forgotten to check?
> 
> Dick



-- 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Slow performance with >1 user on server D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2016-11-10 13:59 +0100
  Re: Slow performance with >1 user on server dlzc <dlzc1@cox.net> - 2016-11-10 06:20 -0800
    Re: Slow performance with >1 user on server D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2016-11-10 16:33 +0100
      Re: Slow performance with >1 user on server dlzc <dlzc1@cox.net> - 2016-11-10 09:32 -0800
        Re: Slow performance with >1 user on server Willie Moore <williem@wmconsulting.com> - 2016-11-11 14:07 -0600
  Re: Slow performance with >1 user on server Mathias <mathias.hakansson@consultec.se> - 2016-11-11 02:05 -0800
    Re: Slow performance with >1 user on server D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2016-11-11 15:58 +0100
  Re: Slow performance with >1 user on server "Jamal" <noooospam@example.com> - 2016-11-12 15:02 -0500
    Re: Slow performance with >1 user on server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2016-11-13 10:41 +0100
  Re: Slow performance with >1 user on server "Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be> - 2016-11-14 08:41 +0000
    Re: Slow performance with >1 user on server Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2016-11-14 10:07 +0100
      Re: Slow performance with >1 user on server Massimo Bighelli <info@arcasistemi.it> - 2016-11-14 11:37 +0100
        Re: Slow performance with >1 user on server Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2016-11-14 12:08 +0100
          Re: Slow performance with >1 user on server Massimo Bighelli <info@arcasistemi.it> - 2016-11-14 12:26 +0100
  Re: Slow performance with >1 user on server Martin <Martin@spam.spam> - 2016-11-14 11:32 +0000
    Re: Slow performance with >1 user on server dlzc <dlzc1@cox.net> - 2016-11-14 07:23 -0800
  Re: Slow performance with >1 user on server D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2016-11-16 17:17 +0100
    Re: Slow performance with >1 user on server dlzc <dlzc1@cox.net> - 2016-11-16 09:08 -0800

csiph-web