[Progress Communities] [Progress OpenEdge ABL] Add Time To Live to records; so records get deleted automatically after a period of time

  • Thread starter Thread starter onnodehaan
  • Start date Start date
Status
Not open for further replies.
O

onnodehaan

Guest
Add Time To Live to records; so (log) records get deleted automatically We have a few of tables that contain data that is only usefull for a limited amount of time. For example logging of incoming REST-calls, or the logging when the users login into our ERP. Currently we have a batch engine that we set up to delete those records; but sometimes that batch job isn't run properly or a customer doesn't use our batch engine, so the table can grow to contain 10's of millions of records and take up GB's and GB's of space. I can imagine that their are a lot more use-cases for this feature.

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