Performance Analysis

With the performance analysis tool, you can debug computed columns in data sources to determine how long they take to calculate.

This performance data is calculated per column and also per data source.

Setting up Performance Analysis

Before you can run the performance analyzer on your apps, the feature needs to be activated for your team:

To view performance data for a table:

Using the Performance Analysis Tool

There are two different icons you might see when running performance analysis:

• ⚠️ Indicates that the column or table is computing results slowly and is taking longer than 100ms.
• ✅ Indicates that the column or table doesn’t have any performance issues and is below the 100ms threshold.

Hovering over these icon where they appear (either in the Tables menu or on the computed column names) will display different information. On columns, you will see how long the computation took to calculate. On tables, you will see the maximum time any computed column in that table took to calculate. This time may vary slightly if you check multiple times.

Improving Performance

If you find that a computed column seems too slow, or a warning icon is displayed alerting you to slow processing time, there are several different steps you could try:

1. Check to see if you have computed columns that are dependent on each other, like a chain. Computed columns with dependencies on other computed columns are likely to slow down as they wait for the other columns in the chain to process. Consider consolidating your computed columns to eliminate redundancy.
2. If the computed column is waiting on data from a webhook or third party platform, it may take longer to process as the table waits to receive a valid response.
3. Query columns are often the source of performance issues. Consider replacing query columns with Conditional Relations to improve performance speed. Learn more here.

Frequently Asked Questions