Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #9942
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Slow performance with >1 user on server |
| Date | 2016-11-13 10:41 +0100 |
| Message-ID | <e8qqqaFksf8U1@mid.individual.net> (permalink) |
| References | <7br82c1mvbg0s6isv68j324k9er2nqahg0@4ax.com> <o07shg$hs0$1@news.albasani.net> |
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
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