Implementation limits

This document lists the maximum number of tables, columns, indexes and so on per database.

The number of tables in a database is limited only by available resources.

The number of columns in a table is usually limited by a maximum record size of 8200 bytes (just over 8Kb), e.g. a table could have 64K not-null Bit columns, 32 Text8[255] columns, 100 Text8[80] columns, or 32 LongText8 columns.

Each table can have up to 32 indexes. Index keys can contain any number of key columns, but the total size of the key must not exceed 248 bytes for unique indexes, and 244 bytes for non-unique indexes.

The number of rows in a table is practically limited by available resources.

The maximum size of a transaction is limited by available memory.