Updated: 2022/Sep/29

Please read Privacy Policy. It's for your privacy.


SQLITE3_STMT_STATUS(3)     Library Functions Manual     SQLITE3_STMT_STATUS(3)

NAME
     sqlite3_stmt_status - prepared statement status

SYNOPSIS
     #include <sqlite3.h>

     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.

IMPLEMENTATION NOTES
     These declarations were extracted from the interface documentation at
     line 8667.

     SQLITE_API int sqlite3_stmt_status(sqlite3_stmt*, int op,int resetFlg);

SEE ALSO
     sqlite3_db_status(3), sqlite3_status(3), sqlite3_stmt(3),
     SQLITE_STMTSTATUS_FULLSCAN_STEP(3)

NetBSD 10.99                    August 24, 2023                   NetBSD 10.99