We have tables that are growing over time and are looking for an archiving strategy. The DB is hosted in the cloud so to the best of my knowledge we can't create views or stored procedures. We are thinking of creating a new 'archive' table and moving old data into this table, but are faced with many complexities in retrieving the archived data. Does anyone have any solutions?
Hello Daniel,
Have you gone through this Outsystems data_archiving Documentation it will really help you to fulfill your requirement.
Regards,
Pavan R
Hi Daniel,
Can you please explain which type complexity you are facing to data in archive table.
Thanks
Arun
Below I have explained some ways to store data from big tables in a cloud database that's becoming too large:
1- Make an Archive Table: Create a new table for old data and move it there. This is simple, but getting the old data back might be tricky. You can make it easier by adding special search tools or using a program that's good at dealing with lots of data.
2- Use Cloud Archiving Services: There are services that can help put data from your cloud database into storage. They can shrink the data, keep it safe, and make sure you don't save the same thing multiple times, which saves space and helps things work faster.
3- Split Your Table: Cut your big table into smaller pieces using a smart plan. This can make things work better and also help store old data.
4- Use a Data Warehouse: Imagine a different database just for old data. This is good if you want to keep very old records.