How to Optimize Network Traffic in a Multiuser Application

This article was previously published under Q136770
This article has been archived. It is offered "as is" and will no longer be updated.
One way to optimize the amount of network traffic a multiuser applicationgenerates is to minimize the volume of file hits to server-based files.
To build a multiuser database application that minimizes network traffic,consider the fact that the fewer the number of times your application hasto process server-based files, the less network traffic is generated.

Techniques for reducing network traffic incorporate local-cachingstrategies and dynamic usage systems that pull network files into use onlywhen absolutely necessary. This requires overhead programming, but it canresult in a much more stable, speedy, and reliable network connection.

In a database application, users often need to see only a subset of thedata. In this case, a query to bring what the user needs down into a localtable for manipulation is appropriate. Once the information is local, thereis no further need to access the network until a change is committed.

Whenever you implement a scheme like this, you need to have an effectiveway to handle transaction processing. For more information abouttransaction processing, please see the "Managing Updates with Transactions"section, pages 440-447, the "Programming for Shared Access" chapter of the"Developer's Guide."

Optimizing network traffic requires that you reference network files asfew times as possible, and close these files when your application isfinished with them for a while. It is better to work with local data setsand verify synchronization issues.

For additional information, please see Chapter 4, page 71, of the"Professional Features Guide."
VFoxWin multi-user net

Article ID: 136770 - Last Review: 02/24/2014 08:21:43 - Revision: 1.1

  • Microsoft Visual FoxPro 3.0 Standard Edition
  • kbnosurvey kbarchive KB136770