Forum Discussion
EvanMartinez
7 years agoQuickbase Staff
Hi Orion,
We most often reach out to users when a performance issues becomes significant enough to be caught by our Operations team. These performance issues are more likely in large applications or in environments where multiple applications are interdependent and so have to all stay in the same server together in order to function. While a larger application or dependent application is more likely to raise those performance flags there are larger applications that run without issue. We do often recommend builders consider the possibility of archiving records from tables that are no longer needed on a regular day to day basis or aren't specifically being used for active reporting. I often do this by making a copy of the application without data and then using a table to table import in Quick Base to move those older records out of the main app and into my mirrored archive app. This helps to free up some space in a table that has grown large and to help speed up the application performance when it comes to reporting, searching, and navigation. They aren't hard and fast rules but they are suggested best practices to make sure you and your users are getting the most out of your applications.
We most often reach out to users when a performance issues becomes significant enough to be caught by our Operations team. These performance issues are more likely in large applications or in environments where multiple applications are interdependent and so have to all stay in the same server together in order to function. While a larger application or dependent application is more likely to raise those performance flags there are larger applications that run without issue. We do often recommend builders consider the possibility of archiving records from tables that are no longer needed on a regular day to day basis or aren't specifically being used for active reporting. I often do this by making a copy of the application without data and then using a table to table import in Quick Base to move those older records out of the main app and into my mirrored archive app. This helps to free up some space in a table that has grown large and to help speed up the application performance when it comes to reporting, searching, and navigation. They aren't hard and fast rules but they are suggested best practices to make sure you and your users are getting the most out of your applications.