Beta feature
This is a beta feature, which means we're still developing it. Some functionality may change.
Cache queries from the Pipelines Copy Record step and connected tables to improve performance when syncing data from a table using the same filter.
When caching is enabled, Quickbase stores the results of a query and reuses them for queries with identical filters. This reduces the number of times Quickbase must run the same query and helps data sync operations complete faster.
How caching works
When multiple queries use the same filter, Quickbase processes the first request normally and creates a cache of the results.
Subsequent queries with the same filter retrieve the results from the cache instead of running the query again.
For example, if you query Active employee records and distribute them to 10 apps using a connected table or a pipeline:
The first query runs normally and creates the cache.
The next 9 queries with the same filter retrieve results from the cache.
These queries complete faster because Quickbase doesn’t need to run the query again.
Enable query caching for a table
To enable caching for a table:
Open the table you want to configure
Open Advanced settings
Select Attempt to cache Pipelines and Connected Tables queries to this table
Choose how the cache should behave:
Set a cache time
Clear the cache when data in the table changes
Limits
1 MB per cache page. Page size is determined dynamically.