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


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

Re: visual objects network performance problem

From Mathias <mathias.hakansson@consultec.se>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: visual objects network performance problem
Date 2012-01-08 22:58 -0800
Organization http://groups.google.com
Message-ID <33284690.25.1326092285979.JavaMail.geo-discussion-forums@yqnt2> (permalink)
References <cQcOq.1304$v14.348@viwinnwfe02.internal.bigpond.com>

Show all headers | View raw


There is an (old) explanation on this phenomena here http://www.superbase.com/services_tech_support_oplocks.htm.

The performance is better now with windows server 2008 together with Windows 7, as this combination of OSs can change the packet size dynamically, that is if there isn't a XP machine on the network as well. So reading the old texts from 2002 gives us an conslution that is still true;

* Microsoft wants us to stop using file sharing databases.
* If we do we will be punished with bad performance.

There are a couple of things you can do to make your application perform better.
* If you want to show a database in a browser
    - Don't use filters, use indexes with conditions instead.
    - Try to keep the record size down (use sub tables for complementary data).
    - Try to keep the file size down (you could move old records to another database).

/Mathias

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