Using SQLite

Name

sqlite3_limit() — Get or set SQLite library limits and maximums

Definition

int sqlite3_limit( sqlite3* db, int limit, int value );

db

A database connection.

limit

The specific limit to set.

value

The new value. If the value is negative, the value will not be set (and the current value will be returned).

Returns

The previous value.

Description

This function gets or sets several of the database connection limits. The limits can be lowered at runtime on a per-connection basis to limit resource consumption. The hard limits are set using the SQLITE_MAX_xxx build options. If an application attempts to set the limit value higher than the hard limit, the limit will be silently set to the maximum limit.

For a full list of the currently supported limits, see http://www.sqlite.org/c3ref/c_limit_attached.html.

See Also

sqlite3_config(), sqlite3_db_config()