Share via

Client/Server Performance Optimization

  • Article

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

  • Connection Use Optimization
    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 server stored procedures, and batching updates.
  • Creating Client/Server Solutions
    Client/server applications combine the functionality of Microsoft® Visual FoxPro® on your local computer with the storage and security benefits provided by a remote server.
  • Client/Server Application Design
    Building on multi-user development technologies, learn how to design a powerful client/server application.
  • Upsizing Visual FoxPro Databases
    Creating local prototypes of your design can reduce development time and costs. When you have a tested local prototype, it is easy and beneficial to upsize your application, so it can take advantage of all the features provided by the remote server.
  • Implementing a Client/Server Application
    You can use SQL pass-through technology to enhance your upsized application. While remote views provide access to server data, SQL pass-through lets you send commands directly to the server using native server syntax, increasing your control and flexibility.