Data Retention Policies, Often Forgotten

  • Comments posted to this topic are about the item Data Retention Policies, Often Forgotten

  • I feel for you. I encounter this issue many more times than I would like too.

    I once read a comment suggesting that if you are not doing a join to it then you don't want it in a relational database. So, those logs could have been written to text files (even the most recent 3 months).

  • @dave_rogers: I disagree with your "rule". It is often much easier to query a log table (even if it will be never joined to whatever) than to read / search / scan a bunch of log.txt files.

    And to come back to the original article: if your application starts to lag because you have many (outdated or not) rows in your tables, you should check your indexes, queries and maybe partitioning (even if you should still delete outdated stuff)

    • This reply was modified 3 years, 1 month ago by  Thomas Franz.
    • This reply was modified 3 years, 1 month ago by  Thomas Franz.

    God is real, unless declared integer.

  • This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply