Scheduling the data from one table to another

tanmay3 years ago

Hello
I am facing an issue with data overloading so I wanted to store my data from one table to another table of another database on the basis of a period of 30 days. So can you help me with the solution that how can I implement this?

Anton Tananaev3 years ago

It's going to be very complicated to implement. Why not just remove the old data?

tanmay3 years ago

Actually, we need to store the old data for testing purposes, so is there any solution present for the restoring of data?

Anton Tananaev3 years ago

What is overloading then and how splitting it into different tables would solve the problem?

tanmay3 years ago

The thing is that we are collecting data into some tables so excess of data is slowing down the api calls , that's why we want to restore it to another database's table

Anton Tananaev3 years ago

Instead of reinventing the wheel, you should properly configure your existing database. If it's set up correctly, there won't be any difference whether the data is in the same table or different.