[progress Communities] [progress Openedge Abl] Forum Post: Re: High Create / Delete Tables...

  • Thread starter George Potemkin
  • Start date
Status
Not open for further replies.
G

George Potemkin

Guest
> George - ran chanalys and got: In 5 areas the total number of blocks found in the RM chains is 1,093,331. > 1,123,270 RM block(s) found in the database. > 42.47% of the RM block space is used. Or 97% of all data blocks (RM blocks) are in the RM chains. If I understand correctly you don't have a real performance issue but are looking for the "best practice" recommendations. These recommendations are focused on /storing/ data in database. In your case the application creates a lot of data and then deletes the most of the records. It's rather usual that this seems to be true almost for the whole database. I would begin from a different question: "how to check if my application has the performance issues?"

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