Archiving Data
It has been my experience that data based applications run better when old generally irrelevant records are archived into a historical archive table. Typically these records are still required for hi...
Forum Discussion
You are certainly planning head. but you are absolutely correct, that like a frog getting slowly boiled, apps do slow down as the amount of data increases.
If you have the luxury of lots of room in your plan for the # of apps, the easiest way is to simply make copy of your app and then lock down the role access to view only. Before you do that you would make some reports in your large tables to purge out old data (but do not yet purge).
Then you would copy the app with data. Then you can go ahead and manually run the purge report and use the More .. button to delete the old records.
You may choose to purge the new data from your archive app, just so there is no overlap.
If you have the luxury of lots of room in your plan for the # of apps, the easiest way is to simply make copy of your app and then lock down the role access to view only. Before you do that you would make some reports in your large tables to purge out old data (but do not yet purge).
Then you would copy the app with data. Then you can go ahead and manually run the purge report and use the More .. button to delete the old records.
You may choose to purge the new data from your archive app, just so there is no overlap.
Take a look at Quick Base University under Advanced > Record Archiving and Snapshotting. The lesson utilizes a secondary application called Zapier (much cheaper then Workato) which you can automate the process instead of manually archiving. Additionally this can be done in a similar fashion with Quick Base Automations but if you are limited to only purging 1000 records per run which may cause issues depending on your needs.
For the most part I don't run into size limitations but I do have a couple apps with tables the run into the millions of records being added each year and archiving is a must for them. You can keep an eye on the apps through Show app statistics under App management to monitor size of tables.
For the most part I don't run into size limitations but I do have a couple apps with tables the run into the millions of records being added each year and archiving is a must for them. You can keep an eye on the apps through Show app statistics under App management to monitor size of tables.
