# Shrink a table's columns with Optimize Datatable

> Optimize Datatable reduces the storage size of a table's text and choice columns to fit the data they hold, freeing room in the table's rows.

Source: https://tadabase.com/docs/data/optimize-a-large-table  
Status: Verified Nov 17, 2026. Checked against the current product

Each field of a table takes room in the table's rows, sized for the longest value the field could hold. **Optimize Datatable** sets a smaller size on fields whose stored values are much shorter than that, based on the longest value each one holds today. Use it on a wide table that is running short of room for new fields.

## Before you start

> **Back up the app first:** The builder warns that optimizing can't be undone and can affect or corrupt your table. Take a backup before you optimize. See [Back up and restore your app](https://tadabase.com/docs/settings/backing-up-and-restoring-your-app).

- Optimize Datatable is available on some plans only. On other plans, the button shows a message instead.
- A smaller size limits how long a value in that field can be. Choose a size that leaves room for the longest values you expect to save later.

## Optimize a table

1. **Open Application Configuration** In the builder, press **Shift+I**. The **Application Configuration** window opens.
2. **Open Optimize Datatable** Click **Optimize Datatable** at the bottom of the window.
3. **Choose the table** In **Select Datatable**, choose the table. The window shows its number of **Records** and **Eligible Fields**, then lists each field it can resize.
4. **Pick fields and sizes** Tick each field to optimize. Its **New Size** starts at the length of the longest value stored in it. Change it if you want more room; it must stay within the **Min** and **Max** shown under the box.
5. **Optimize** Click **Optimize Selected Fields**, tick **I understand this action is irreversible.**, and click **Optimize Now**.

| Column | What it shows |
| --- | --- |
| **Field Name** | The field and its type. Name and address fields are listed once per part, such as **First Name** or **City**. |
| **Field ID** | The field's ID. |
| **Current Size** | The size the field's column has now. |
| **Current Value Stored Size** | The length of the longest value stored in the field. |
| **New Size** | The size to set. **Min** is the longest stored value (15 when the field is empty); **Max** is the field's original size. |
| **Reset** | Shown for a field you optimized before: puts its column back to its original type and size. |

## Which fields can be optimized

Text, Email, Phone, Number, Currency, Slider, Select, Multi-Select, Checkbox, Radio, Decision Box, Name and Address fields, when their values are stored as text. Hidden and system fields are left out. If a field's stored values are already longer than its original size, it is greyed out with the reason, and it can't be reduced.

If the window says **No eligible columns found for this datatable.**, the table has no field that can be resized.

## Put a field back to its original size

Open **Optimize Datatable** again and choose the table. Next to a field you optimized, click **Reset**, tick **I understand this will reset the column.** and click **Reset**. The field's column goes back to its original type and size.
