UltraLite Database User's Guide
UltraLite Databases
The following table lists the absolute limitations imposed by data structures in the software on the size and number of objects in an UltraLite database. In most cases, the memory, CPU, and storage device of the computer impose stricter limits.
| Item | Limitation |
|---|---|
| Number of connections per database | 14 |
| Number of columns per table | 65535 but limited by row size 1 |
| Number of indexes | 65535 |
| Number of rows per database | Limited by persistent store |
| Number of rows per table | 65534 |
| Number of tables per database | Approximately 1000 2 |
| Number of tables referenced per transaction | No limit |
| Row size | Approximately 4 kb (compressed). LONG VARCHAR and LONG BINARY values are stored separately, and are in addition to the 4 kb limit. |
| File-based persistent store | 2 Gb file or OS limit on file size |
| Palm Computing Platform database size |
128 Mb (Primary storage)
2 Gb (expansion card file system) |
For other limitations, see Overview of SQL support in UltraLite.
1 Row size is limited to about 4 kb, so the practical limit on the number of columns per table is much smaller than this: much less than 4000 in most situations.
2 If you set the page size to 2 kb, the maximum number of tables is reduced to approximately 500.
Adaptive Server Anywhere features not available in UltraLite databases
UltraLite tables must have primary keys