# Speed up slow formula fields with the query optimizer

> Formula Performance finds slow formulas, rollups and equations in your app and suggests fixes you can apply and roll back from General Settings.

Source: https://tadabase.com/docs/data/field-query-optimizer  
Status: Verified Nov 17, 2026. Checked against the current product

**Formula Performance** looks at the formulas, rollups and equations in your app, finds the ones that take a long time to calculate, and suggests changes that make them faster. Some changes you apply with one click and can roll back later; others are advice you make yourself.

> **Plan feature:** Formula Performance is included only on plans that have the query optimizer. If you don't see it on the **Performance** tab, your plan doesn't include it. For an app someone else owns, it is shown when either your plan or the app owner's plan includes it.

## Open Formula Performance

1. **Open General Settings** In the builder, open **Settings** and click **General Settings**.
2. **Go to the Performance tab** Click the **Performance** tab and scroll to **Formula Performance**.
3. **Run an analysis** The first time, the section says the optimizer has not been initialized for this app. Click **Analyze now** to scan your formulas. Run it again any time to refresh the list; **Last analyzed** shows when it last ran.

The analysis runs in the background and does not change your live app. If it finds nothing, the section says your formulas look healthy.

## Read a recommendation

Recommendations are sorted with the most serious first. Each one shows:

- A severity label: critical, high, medium or low.
- What to change and why, and the field and table it is about.
- How slow the formula has been: its worst run time and how many runs were measured.
- **View SQL change**, which opens the exact database change the fix would make.

A recommendation marked **Manual change — review required** has no one-click fix. Read the advice and change the formula yourself, or click **Dismiss** to hide it.

## Apply a fix and roll it back

1. **Apply** Click **Apply** on a recommendation. When a fix converts a field into a column the database calculates by itself, you are asked to confirm first, because it rebuilds the table.
2. **Check it** The fix moves to **Applied & reversible**, with the date it was applied.
3. **Roll back if needed** Click **Roll back** to undo the change. Every change is logged.

| Kind of fix | What it does |
| --- | --- |
| Add an index | Adds a database index so the formula finds its records faster. Index changes run online, without stopping saves. |
| Convert to a database column | The database calculates the field itself whenever a record is saved. This rebuilds the table, and saves to that table wait until it finishes, which can take minutes on a large table. Apply it at a quiet time. |
| Rewrite a rollup | Calculates the rollup for the whole table in one pass instead of once per record. |

> **After converting a field:** While a field is calculated by the database, a change you save to its formula is not applied yet. Turn **Calculate in Real Time** on to apply it, or roll back the conversion in Formula Performance.

If an apply fails, the recommendation stays in the list with a note. Retry it or dismiss it.

## Optimize one rollup in its field settings

On plans with the optimizer, Rollup and Complex Formula fields have an **Optimized Query** switch (marked beta) in their field settings. Turn it on to calculate the rollup for the whole table in one pass instead of once per record. When you save, the new query is tested against your data; if the results differ, the field keeps its original query.

## See how long a formula takes

Formula fields show when they were last calculated, and the error if the last calculation failed. Where equation logs are turned on for your app, the **Logs** button at the top of a formula field's settings opens **Equation Logs**, with the start time, end time and duration of each run. See [Equation logs](https://tadabase.com/docs/settings/equation-logs).
