Does the SQLite database have known size restrictions?

SQLiteDoes the database have a known size limit?

The database size isRestrictionsIn 2 TB (241 bytes), this is the theoryRestrictions. In fact, you shouldSQLiteDatabase sizeRestrictionsLess than GB to avoid running performance problems. If you need to store GB or more data in one database, consider using the Enterprise Edition database designed for this purpose.

Theoretical number of rows in a databaseRestrictionsIt is 264-1. Obviously, you are reaching the number of rows.RestrictionsThe file size is exceeded beforeRestrictions. Currently, one row can store 230
Bytes data. The basic file format supports a row size of about 262 bytes.

The number of tables, indexes, or the number of fields in the table and index may also exist.RestrictionsBut no one knows what it is. In fact, when a new database is opened,SQLiteTo read and analyze the initial SQL statements for all tables and index declarationsSQLite3_open () is the best performance. It is best to reduce the number of declared tables. Similarly, even if the number of fields in the table is notRestrictionsThere are too many. Only 31 fields starting with the table are optimized. You can add any number of fields to an index, but indexes with more than 30 fields are not used to optimize the query.

The table, index, view, trigger, and field names can be arbitrarily long, but the SQL function nameSQLite3_create_function () API creation) cannot exceed 255 characters.