Optimizing Client/Server Performance

When you have implemented your client/server application, you might find areas where you'd like to improve performance. For example, you can fine-tune your application to gain maximum performance by speeding up forms and queries and increasing data throughput.

This section discusses optimization strategies for application performance on the client, network, and server.

In This Section

Client/Server Design for High Performance

Building a fast, high-performance client/server application with Microsoft® Visual FoxPro® involves taking advantage of the tremendous speed of the Visual FoxPro engine.

Optimizing Connections

Establishing a connection uses time and memory on both the client and the server. When you optimize connections, you balance your need for high performance against the resource requirements of your application.

Speeding Up Data Retrieval

You can speed up data retrieval by managing the number of rows fetched during progressive fetching, controlling fetch size, and using delayed Memo fetching.

Query and View Acceleration

You can improve query and view performance by adding indexes, optimizing local and remote processing, and optimizing parameter expressions.

Form Acceleration

When you design a form based primarily on server data, take a minimalist approach for the best performance.

Performance Improvement on Updates and Deletes

You can speed up Update and Delete statements by, adding timestamps to your remote tables, using the CompareMemo property, using manual transaction mode, using stored procedures on a remote server, and batching updates.

Related Sections

Creating Applications

Discusses how to create Visual FoxPro application, which may include one or more databases, a main program that sets up the application's system environment, and a user interface comprised of forms, toolbars, and menus.

How to: Set the Starting Point

Describes how the main file is the starting point for your application, and can consist of a program or form. When your application is run, Visual FoxPro launches the main file for your application, which in turn runs all other components as needed.

How to: Initialize the Environment

Setting up the application environment is the first task that a main file or application object must accomplish.

How to: Control the Event Loop

Learn how to establish an event loop to, which causes Visual FoxPro to begin processing user events such as mouse clicks and keystrokes. This occurs after the environment is set up and you've displayed the initial user interface.

Creating Applications with the Application Framework

Explains how to create applications with the Application Framework using the Application Wizard and the Application builder.

Creating the User Interface

Learn how creating forms, classes, controls, and toolbars can provide a rich set of tools for your user interface.

Upsizing Visual FoxPro Databases

Explains how to use the upsizing wizards to move databases, tables, and views from your system to a remote Microsoft SQL Server.

Creating International Applications

Describes how you can design and develop your Visual FoxPro applications so they are as effective internationally as domestically.

© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic