Showing content from https://sqlite.org/c3ref/c_limit_attached.html below:
Run-Time Limit Categories
Small. Fast. Reliable.
Choose any three.
#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.
-
SQLITE_LIMIT_LENGTH
-
The maximum size of any string or BLOB or table row, in bytes.
-
-
SQLITE_LIMIT_SQL_LENGTH
-
The maximum length of an SQL statement, in bytes.
-
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.
-
SQLITE_LIMIT_EXPR_DEPTH
-
The maximum depth of the parse tree on any expression.
-
SQLITE_LIMIT_COMPOUND_SELECT
-
The maximum number of terms in a compound SELECT statement.
-
SQLITE_LIMIT_VDBE_OP
-
The maximum number of instructions in a virtual machine program used to implement an SQL statement. If sqlite3_prepare_v2() or the equivalent tries to allocate space for more than this many opcodes in a single prepared statement, an SQLITE_NOMEM error is returned.
-
SQLITE_LIMIT_FUNCTION_ARG
-
The maximum number of arguments on a function.
-
SQLITE_LIMIT_ATTACHED
-
The maximum number of attached databases.
-
SQLITE_LIMIT_LIKE_PATTERN_LENGTH
-
The maximum length of the pattern argument to the LIKE or GLOB operators.
-
SQLITE_LIMIT_VARIABLE_NUMBER
-
The maximum index number of any parameter in an SQL statement.
-
SQLITE_LIMIT_TRIGGER_DEPTH
-
The maximum depth of recursion for triggers.
-
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.
RetroSearch is an open source project built by @garambo
| Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4