Hi,
I designed an enterprise application and I am wondering what is the best solution for archiving the data.
I cannot keep in the database more than 2-3 years worth of data, otherwise, the database will get slow. (the company has hundreds of thousands of records per year)
So my question is what's the best method for archiving data, and how can I make it easy for the user to access the archived data, in case they decide to lokkup something that was archived ?
Thank you
I designed an enterprise application and I am wondering what is the best solution for archiving the data.
I cannot keep in the database more than 2-3 years worth of data, otherwise, the database will get slow. (the company has hundreds of thousands of records per year)
So my question is what's the best method for archiving data, and how can I make it easy for the user to access the archived data, in case they decide to lokkup something that was archived ?
Thank you