Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #2789
| From | "Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: visual objects network performance problem |
| Date | 2012-01-09 08:42 +0000 |
| Organization | A noiseless patient Spider |
| Message-ID | <jee99b$gu8$1@dont-email.me> (permalink) |
| References | <cQcOq.1304$v14.348@viwinnwfe02.internal.bigpond.com> |
Paul, The time of 27 seconds is the 'real' time for accessing the data over the network, when no caching is performed. However, when 'windows' see that there is only 1 computer accessing the dbf-file, it pushes the whole file to this computer, so access takes about 4 seconds on your 'terminal'. As soon as another user on another 'terminal' or server also opens the same data, the cache is deleted on the terminal-computer, and real access over the network has to be done. The principle of caching exist already very long (win95 - win2000 - winXP - etc) but from Windows VISTA (and win7) the caching is very efficient. This is done by 'SMB2'. WinXP and before are using 'SMB' which is less efficient. Dirk Paul Harrison wrote: > I have a network performance problem with a visual objects > application. I am hoping there is somebody who can explain what is > happening so that I can solve the problem. > > On a terminal where the application and the data are pulled from the > server it takes 3-4 secs to read and report on 8500 records of a dbf > server (cdx). To do the same on the server takes about the same time. > So there is little overhead imposed by the network. > > If the user on the server has the same server open then the same > operation on the terminal as above now takes 27 secs. If the user on > the server closes the server (window) the above operation on the > terminal still takes 27 secs. I should at this point tell you the > server is opened in shared mode, readwrite with concurrencycontrol > set to ccoptimistic. The application is only processing the records > to generate a report (no writing to the file). It also makes no > difference if we turn off notification on the server. > > One further interesting observation is that before processing the > report we close the server and then reopen it (using > self:use(dbserver) on the window (clears client list of the server > ?). This appears to clear the effect of the server having been open > on the server, that is the report takes 3-4 secs again. > > I cannot understand why moving through server records takes upto 10 > times longer on a terminal if the server is also open on the server. > > Any information would be welcome and appreciated. > > > Paul Harrison --
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
visual objects network performance problem "Paul Harrison" <stable_eyes@msn.com.au> - 2012-01-08 19:37 +1100
Re: visual objects network performance problem "Willie Moore" <williem@wmconsulting.com> - 2012-01-08 14:13 -0600
Re: visual objects network performance problem Mathias <mathias.hakansson@consultec.se> - 2012-01-08 22:58 -0800
Re: visual objects network performance problem "Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be> - 2012-01-09 08:42 +0000
Re: visual objects network performance problem Sherlock <sherlock@sherlock.com.au> - 2012-01-13 07:15 -0800
Re: visual objects network performance problem Martin <spam@spam.spam> - 2012-01-18 11:09 +0000
Re: visual objects network performance problem "Marc Verkade [Marti]" <marcatm@rti.nl> - 2012-01-19 00:13 +0100
csiph-web