Kbase P3648: How to improve performance in client/server mode
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/10/2003 |
|
Solution ID: P3648
GOAL:
How to improve performance in client/server mode
FIX:
Running in client/server mode has an overhead due to the data exchange over the network. Here are a couple of tuning tips to improve performance.
A) Be sure that you only retrieve the appropriate field list by using the
FIELDS option for queries. This can be quite important.
For more information on the FIELDS option, see the Progress Language
Reference, Chapter "4GL Reference", "Record Phrase" section.
B) Consider using these two parameters:
-Mm Message Buffer Size
-cache Schema Cache File
For more information on -Mm and -cache, see the Progress Startup Command and
Parameter Reference, Chapter "Startup Parameter Descriptions".