[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: checkpoints

  • Thread starter Thread starter Rob Fitzpatrick
  • Start date Start date
Status
Not open for further replies.
R

Rob Fitzpatrick

Guest
> So, how do you reduce it? Assuming you are using the Enterprise RDBMS license, you can try to reduce buffers flushed at checkpoint by ensuring that you are running an APW; you might need more than one on a very busy system with lots of update activity. Larger BI cluster size will space checkpoints farther apart, giving the APWs more time to do their job of writing dirty blocks.

Continue reading...
 
Status
Not open for further replies.
Back
Top