Small. Fast. Reliable.
Choose any three.
Search for:

SQLite C Interface

Run-Time Limit Categories

#define SQLITE_LIMIT_LENGTH                    0
#define SQLITE_LIMIT_SQL_LENGTH                1
#define SQLITE_LIMIT_COLUMN                    2
#define SQLITE_LIMIT_EXPR_DEPTH                3
#define SQLITE_LIMIT_COMPOUND_SELECT           4
#define SQLITE_LIMIT_VDBE_OP                   5
#define SQLITE_LIMIT_FUNCTION_ARG              6
#define SQLITE_LIMIT_ATTACHED                  7
#define SQLITE_LIMIT_LIKE_PATTERN_LENGTH       8
#define SQLITE_LIMIT_VARIABLE_NUMBER           9
#define SQLITE_LIMIT_TRIGGER_DEPTH            10
#define SQLITE_LIMIT_WORKER_THREADS           11

These constants define various performance limits that can be lowered at run-time using sqlite3_limit(). The synopsis of the meanings of the various limits is shown below. Additional information is available at Limits in SQLite.

R-61987-00541:[
SQLITE_LIMIT_LENGTH
The maximum size of any string or BLOB or table row, in bytes.
]

R-09808-17554:[

SQLITE_LIMIT_SQL_LENGTH
The maximum length of an SQL statement, in bytes.
 ]

R-43996-29471:[

SQLITE_LIMIT_COLUMN
The maximum number of columns in a table definition or in the result set of a SELECT or the maximum number of columns in an index or in an ORDER BY or GROUP BY clause.
 ]

R-12723-08526:[

SQLITE_LIMIT_EXPR_DEPTH
The maximum depth of the parse tree on any expression.
 ]

R-07801-24468:[

SQLITE_LIMIT_COMPOUND_SELECT
The maximum number of terms in a compound SELECT statement.
 ]

R-21339-62938:[

SQLITE_LIMIT_VDBE_OP
The maximum number of instructions in a virtual machine program used to implement an SQL statement. This limit is not currently enforced, though that might be added in some future release of SQLite.
 ]

R-59001-45278:[

SQLITE_LIMIT_FUNCTION_ARG
The maximum number of arguments on a function.
 ]

R-41778-26203:[

SQLITE_LIMIT_ATTACHED
The maximum number of attached databases. ]

R-12940-37052:[

SQLITE_LIMIT_LIKE_PATTERN_LENGTH
The maximum length of the pattern argument to the LIKE or GLOB operators.
 ]

R-42363-29104:[

SQLITE_LIMIT_VARIABLE_NUMBER
The maximum index number of any parameter in an SQL statement. ]

R-61726-11117:[

SQLITE_LIMIT_TRIGGER_DEPTH
The maximum depth of recursion for triggers.
 ]

R-19249-32353:[

SQLITE_LIMIT_WORKER_THREADS
The maximum number of auxiliary worker threads that a single prepared statement may start.
 ]

See also lists of Objects, Constants, and Functions.