System performance is generally assessed in terms of response
time and throughput rates under differing processing and configuration
conditions. To attack the performance problems, there are several questions
should be asked first:
How much application logic should be remotely executed?
How much updating should be done to the database server over
the network from the client workstation?
How much data should be sent to each in each transaction?
According to Hamilton, the performance problems are most often the result
of the client or server being configured inappropriately.
The best strategy for improving client-sever performance is a three-step process.
First, execute controlled performance tests that collect the data about
volume, stress, and loading tests. Second, analyze the collected data. Third,
examine and tune the database queries and, if necessary, provide temporary data
storage on the client while the application is executing.