---
title: "Database Limits"
canonical: "https://help.agiloft.com/space/HELP/43718536/Database+Limits"
format: markdown
---
When defining tables and columns, be aware of a fixed row size limit, and use care in designing your data model so the row size limit is not exceeded. The default row size limit for most KBs is approximately 8126, determined by the MySQL default page size of 16KB, but the row size limit might differ for your particular KB. You can contact Support for assistance in determining if your KB has a different row size limit.

Consider the following best practices to manage row size and remain within the limit:

- Split different types of data into different tables.
- Only import the linked fields that are really needed. As noted in the table below, each linked field that you select to be displayed takes up space.
- Unless the field needs to be indexed, use Text fields in place of Short Text fields. Note however, that Text fields cannot be set as unique. If you are using Microsoft SQL Server instead of MySQL, it also has a limitation that prevents Text fields from being indexed for rapid searching.
- Set Short Text fields to the smallest reasonable maximum length. For example, for a field intended to hold a first name, you might specify a maximum length of 20, rather than accepting the default of 70.
- For [History](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43716066), only track the fields that really need to be tracked.

# Size Considerations by Field Type

The following table details the correspondence between the Agiloft [field types](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43714437) and the corresponding MySQL data types, together with the amount of space required for each.

| **Field Type** | **MySQL Datatype** | **Size in bytes** | **Comments** |
| --- | --- | --- | --- |
| Email | varchar(70) | Maximum field length * 4 + 2<br>Default: 282 | Maximum field length is specified by admin, default is 70 |
| Text | mediumtext | 11 |  |
| Telephone/fax | varchar(70) | Maximum field length * 4 + 2<br>Default: 282 | Maximum field length is specified by admin, default is 70 |
| Type of object | bigint(20) | 8 |  |
| Date/Time | datetime | 8 |  |
| Short Text | varchar(255) | Maximum field length * 4+2<br>Default: 282 | Maximum field length is specified by admin, default is 70 |
| Append Only Text | mediumtext | 11 |  |
| Password | varchar(128) | Maximum field length * 4 + 2<br>Default: 514 | Maximum field length is specified by admin, default is 128 |
| Integer | int(10) | 4 |  |
| Currency | double | 8 |  |
| Email Pager | varchar(70) | Maximum field length * 4 + 2<br>Default: 282 | Maximum field length is specified by admin, default is 70 |
| Elapsed Time | bigint(20) | 8 |  |
| File With Versioning | mediumtext | 11 |  |
| Floating point | double | 8 |  |
| Heat Bar | int(10) | 4 |  |
| Image with Versioning | mediumtext | 11 |  |
| Linked Logical Name | bigint(20) | 8 |  |
| Long Integer | bigint(20) | 8 |  |
| Percentage | double | 8 |  |
| Time | time | 3 |  |
| URL | mediumtext | 11 |  |
| Variable Formula | mediumtext | 11 |  |
| Singleton check | int(10) | 4 |  |
| Multi Choice | varchar(255) | 255 * 4 + 2 = 1022 |  |
| Choice | integer | 4 |  |
| Linked Field (MVE+fast search) | mediumtext | 11 * number of imported fields |  |
| Linked Field (MVE+no fast search) |  | 0 | No physical column created in the viewable table |
| Linked Field(other types) |  | Source field length | Same data type and length as the source field |
| Compound | varchar(x) | Maximum field length * 4 + 2<br>Default: 398 | Maximum field length is specified by admin, default is 99 |
| Calculated Result | double | 8 |  |
| Communications Search Result |  | 0 | No physical column created in the viewable table |
| History |  | 2 * length of tracked fields | No physical column created in the viewable table, but History stores the value of tracked fields, before and after each edit, in an internal table. This internal table may encounter the 64K limit if a lot of fields are tracked. |
| Action Button |  | 0 | No physical column created in the viewable table |


# MSSQL Size Considerations

Microsoft SQL Server has a limitation of 8060 on row size, but as detailed below, it keeps more of the data in internal tables.

> 📝 This applies to very few organizations, as most use MySQL. Only reference this table if you know you are using MSSQL.

| **Agiloft Datatype** | **MSSQL Datatype** | **MSSQL size in bytes** | **Comments** |
| --- | --- | --- | --- |
| Email | nvarchar(70) | Max(2, Min(26, Length specified by admin))<br>Default: 26 | Length specified by admin + 2, but if the specified length is greater than 24, only 26 bytes are used in the visible table |
| Text | ntext | 16 |  |
| Telephone/fax | nvarchar(70) | Max(2, Min(26, Length specified by admin))<br>Default: 26 | Length specified by admin + 2, but if the specified length is greater than 24, only 26 bytes are used in the visible table |
| Type of object | bigint | 8 |  |
| Date/Time | datetime | 8 |  |
| Short Text | nvarchar(70) | Max(2, Min(26, Length specified by admin))<br>Default: 26 | Length specified by admin + 2, but if the specified length is greater than 24, only 26 bytes are used in the visible table |
| Append Only Text | ntext | 16 |  |
| Password | nvarchar(128) | Max(2, Min(26, Length specified by admin))<br>Default: 26 | Length specified by admin + 2, but if the specified length is greater than 24, only 26 bytes are used in the visible table |
| Integer | int | 4 |  |
| Currency | float | 8 |  |
| Email Pager | nvarchar(70) | Max(2, Min(26, Length specified by admin))<br>Default: 26 | Length specified by admin + 2, but if the specified length is greater than 24, only 26 bytes are used in the visible table |
| Elapsed Time | bigint | 8 |  |
| File With Versioning | ntext | 16 |  |
| Floating point | float | 8 |  |
| Heat Bar | int | 4 |  |
| Image with Versioning | ntext | 16 |  |
| Linked Logical Name | bigint | 8 |  |
| Long Integer | bigint | 8 |  |
| Percentage | float | 8 |  |
| Time | datetime | 8 |  |
| URL | ntext | 16 |  |
| Variable Formula | ntext | 16 |  |
| Singleton check | int | 4 |  |
| Multi Choice | nvarchar(255) | 26 |  |
| Choice | int | 4 |  |
| Linked Field (MVE+fast search) | ntext | 16 |  |
| Linked Field (MVE+no fast search) |  | 0 | No physical column created in the viewable table |
| Linked Field(other types) |  | Source field length | Same data type and length as the source field |
| Compound | nvarchar(99) | Max(2, Min(26, Length specified by admin))<br>Default: 26 | Length specified by admin + 2, but if the specified length is greater than 24, only 26 bytes are used in the visible table |
| Calculated Result | float | 8 |  |
| Communications Search Result |  | 0 | No physical column created in the viewable table |
| History |  | 2 * length of tracked fields | No physical column created in the viewable table, but History stores the value of tracked fields, before and after each edit, in an internal table. This internal table may encounter the 8060 byte limit if a lot of fields are tracked. |
| Action Button |  | 0 | No physical column created in the viewable table |