Database tuning

18 Jan Basic OpenEdge DB Tuning Part II: BI Cluster Size

Posted at 15:28h in Database tuning

Abstract: In an OpenEdge DB the BI Cluster changes (checkpoints) are write intensive and costly. Increase BI Cluster size, so that a cluster needs 5 minutes or longer to fill up....

Read More

14 Dec Basic OpenEdge DB Tuning: -B / Cache

Posted at 14:57h in Database tuning

Tuning an OpenEdge DB on basic level requires only a few parameters to be considered. The -B is the most valuable parameter. When set to 100 000 (one hundred throusand) the DB will use 100000 times the size of a DB block as a cache. Often enough the -B parameter is not set or much too small. See the -B documentation here ...

Read More