Any tool/utility to housekeep data
Moderators: Developer, Contributor
-
- Posts: 2
- Joined: 17 Jan 2018, 08:46
Any tool/utility to housekeep data
As database is getting bigger, is there any tool to discard the old data from the database e.g. using the creation date as criteria? Thanks!
-
- Posts: 2
- Joined: 17 Jan 2018, 08:46
Re: Any tool/utility to housekeep data
Q1. as we allow more projects using the same mantis due to limited hardware resources and we want to discard those records which are very old (several years ago) to accommodate new projects.
Q2. we want to trim the whole database but not specific tables.
Q2. we want to trim the whole database but not specific tables.
Re: Any tool/utility to housekeep data
Might be no good idea.raymondfong wrote:we want to discard those records which are very old (several years ago)
Typically some months later you will hear users asking for removed data.
That's why I am asking for the biggest table, e.g. it could be the file attachments table if you store attachments in database.
In this case, it could be better to keep all data, but just move the attachments to file system.