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


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

Re: visual objects network performance problem

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>

Show all headers | View raw


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


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