This article explains the size limits of Quickbase tables, solutions for increasing data storage, and ways to optimize apps to handle more data.
In this article
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