Kbase P38652: Suggestions to increase Dynamics performance
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/2/2006 |
|
Status: Unverified
GOAL:
Suggestions to increase Dynamics performance
FACT(s) (Environment):
Dynamics 2.0A
Progress 9.1D
FIX:
1) Make sure the client sessions (both GUI and AppServer) are using the -Bt startup parameter (preferably with a value of at least 256 ... -Bt 256) (preferably 1000). This parameter can have varying degrees of success depending on configuration and environment. It is therefore recommended that the specified values are tested thoroughly in the specific environment until an optimum value is reached.
2) Make sure the client session (both GUI and AppServer) are using the -q startup parameter.
3) Make sure both the Dynamics database and the application database are using a decently sized buffer pool. This is done with the -B startup parameter. For an 8K block size database a recommend value of at least 512 for the Dynamics database would be in order (1024 would be even better).
4) The .r code should be local to the client session and not be retrieved from a remote file server.
5) The -T startup parameter should point to a local hard disk.