Post reply

Data Retention Policies, Often Forgotten

  • October 8, 2021 at 12:00 am

    #3932815

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

  • October 8, 2021 at 8:32 am

    #3938734

    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).

  • October 8, 2021 at 11:47 am

    #3938787

    @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 2 years, 6 months ago by  Thomas Franz.
    • This reply was modified 2 years, 6 months ago by  Thomas Franz.

    God is real, unless declared integer.

  • October 9, 2021 at 6:39 am

    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