Kbase 22022: Dynamics: Deployment Performance Tips
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/05/2002 |
|
The following tips can help you improve the performance of your Dynamics based application:
1) Client sessions and AppServer sessions should use the -q and -Bt
startup parameters.
2) The .r code for both Dynamics and your application should not
reside on a remote file system (if at all possible).
3) The AppServer should connect to any databases using shared memory
connections if at all possible.
4) For Windows, use Microsoft's Windows Update utility and install
all updates for the operating system.
5) Make sure the latest patches for Progress 9.1C are installed. In
particular, if you are running 9.1C and are using a patch level
below 9.1C21 you should install at least the 9.1C21 patch.
6) Make absolutely certain that the fields used in any WHERE clause
or filter associated with a Dynamic Combo or Dynamic Lookup is
indexed (preferably with each field as a single component
index). This tip alone may be the major reason for poor
performance.