This article explains the size limits of Quickbase tables, solutions for increasing data storage, and ways to optimize apps to handle more data.
Table size limits
A single table in Quickbase has a size limit of 500 MB of data by default. This limit applies to all plans and is set to ensure the overall performance of your app and the Quickbase platform.
This limit is flexible, however, and can be increased depending on the current and expected performance of your table and app.
In most cases, Quickbase tables do not require more than 500 MB. Deleting empty fields, for example, is an effective way to free up significant space. For more strategies for building high-performing apps with sufficient table data storage, refer to Optimize for size in this article.
Other table limits
Maximum record ID: 4,294,967,295
Number of rows and columns: No limit
Number of fields: No limit
Number of tables in an app: No limit
Request a table size increase
Realm and account admins can request to increase the 500 MB default limit for a single table:
For accounts with services, reach out to your account team.
For accounts without services, open a support ticket.
We evaluate all requests to make sure a size increase is a necessary and effective solution. There are several factors we take into consideration when assessing requests, including:
Empty fields
Continued growth of the table
Current app and table performance
Table transaction volume
Archiving strategy
Anticipated changes to the app (like schema and permissions)
The overall configuration of the app ecosystem in line with Quickbase best practices and limits
Your request for an increase may or may not be approved after a thorough evaluation of these factors. Either way, we work with you to find the best solution for your specific needs.
Optimize for size
Besides requesting an increase in space, there are several ways to ensure your app can store all the data it needs while still performing well:
Scale out
Delete empty fields
Use advanced performance tools
Scale out
The performance of an app depends on its complexity, size, and traffic. As these aspects increase, its speed may suffer. A solution to this is to scale it out over multiple apps.
Instead of having a single app with complex and large tables with heavy traffic, divide it into distinct apps. This would spread out your functions over more Quickbase processing power—improving performance and increasing space for data.
Learn more about sharing data across apps.
Delete empty fields
A way to ensure your tables do not reach the data size limit is to regularly delete unused and empty fields. Since Quickbase runs on an in-memory database designed for speed, even empty fields consume data. Deleting these fields can significantly free up space in your tables.
One way to find which fields you can delete is to check a field’s usage. To do this:
Go to a table’s settings and select Fields.
Hover over a field and select Where is this field used?
In the usage tab, you can learn where it’s used and its number of records with data.
Quickbase also offers APIs for field usage, as well as the Application Analyzer app in the Exchange, which helps you manage apps through bulk updates to table and field properties.
Use advanced performance tools
Quickbase offers advanced performance tools to help optimize the speed and complexity of your apps and tables.
Use the following tools routinely to help your app handle more data:
Performance optimizer – scans an app for performance optimization, which you can apply instantly
Performance insights – identifies performance hotspots and makes recommendations for remediation
Report caching – helps you improve report performance using a cache
Summary field caching – improves performance by only evaluating specified summary fields when data changes in the application—preventing unnecessary re-calculations