Performance Optimisation

Working with big data and complex views

Agilebase automatically takes some measures behind the scenes to maintain high performance as data volumes grow.

There are other mechanisms that can be manually enabled such as caching and increasing the memory assigned to particular views.

Finally, we will be happy to to do all we can to speed up any parts of your application that require it if you contact us. Often, a solution as simple as manually adding an index to a particular field can speed up requests by multiple orders of magnitude.

For really big data projects, there’s also the option of utilising PostgreSQL-compatible database services designed for such tasks, like Citus Data, which we will be happy to provision.

Last modified November 27, 2023: Pivot table example (80c844c)