Manual Page Result
0
Command: sqlite3_stmt_status | Section: 3 | Source: NetBSD | File: sqlite3_stmt_status.3
SQLITE3_STMT_STATUS(3) FreeBSD Library Functions Manual
NAME
sqlite3_stmt_status - Prepared Statement Status
SYNOPSIS
int
sqlite3_stmt_status(sqlite3_stmt*, int op, int resetFlg);
DESCRIPTION
Each prepared statement maintains various SQLITE_STMTSTATUS counters that
measure the number of times it has performed specific operations. These
counters can be used to monitor the performance characteristics of the
prepared statements. For example, if the number of table steps greatly
exceeds the number of table searches or result rows, that would tend to
indicate that the prepared statement is using a full table scan rather
than an index.
This interface is used to retrieve and reset counter values from a
prepared statement. The first argument is the prepared statement object
to be interrogated. The second argument is an integer code for a
specific SQLITE_STMTSTATUS counter to be interrogated. The current value
of the requested counter is returned. If the resetFlg is true, then the
counter is reset to zero after this interface call returns.
SEE ALSO
sqlite3_stmt(3), sqlite3_db_status(3), sqlite3_status(3),
SQLITE_STMTSTATUS_FULLSCAN_STEP(3)
FreeBSD 14.1-RELEASE-p8 December 19, 2018 FreeBSD 14.1-RELEASE-p8