Kbase P17165: How to improve performance on roll forward?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/03/2011 |
|
Status: Verified
GOAL:
How to improve performance on roll forward?
GOAL:
How to speed up AImage Extent roll forward?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
To improve performance of a "roll forward" operation:
- use the startup parameter -B. The default is 20 for single user, suggested values are
1KB database blocksize -B 2048
2KB database blocksize -B 1024
4KB database blocksize -B 512
8KB database blocksize -B 256
A -B value that is too large will make the roll forward process slower as it has to spend a margin of the initial rollforward time allocating the buffer pool.
- Use the "-i" parameter, i.e. "No Crash Protection". However, by doing so the "rfutil -C rollforward retry" functionality cannot be used in the event of roll foward failure.
- Don't use the "verbose" option