Kbase P109098: Performance of prostrct create is slow for large database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/24/2008 |
|
Status: Verified
SYMPTOM(s):
Performance of prostrct create is slow when creating large databases.
Performance of prostrct is good for small databases
FACT(s) (Environment):
UNIX
Progress/OpenEdge Product Family
CAUSE:
Operating system buffer cache can be saturated when performing large data related operations like prostrct create for large volumes of disk changes in short periods of time.
When the OS Buffer Cache is saturated it may delay operations while it writes the OS Buffer Cache.
(On Unix this is typically done with syncd).
FIX:
Review the Operating System suggestions for adjusting the OS Buffer Cache settings and syncd frequency to optimize creation of database extents with prostrct create.