Choose any three.
SQLite Requirement Matrix Details
wal_autocheckpoint.html
Index Summary Markup Original
R-38128-34102-03228-01716-42650-19152-18652-04810 tcl slt th3 src
The sqlite3_wal_autocheckpoint(D,N) is a wrapper around sqlite3_wal_hook() that causes any database on database connection D to automatically checkpoint after committing a transaction if there are N or more frames in the write-ahead log file.
/* IMP: R-38128-34102 */
# EVIDENCE-OF: R-38128-34102 The sqlite3_wal_autocheckpoint(D,N) is a # wrapper around sqlite3_wal_hook() that causes any database on database # connection D to automatically checkpoint after committing a # transaction if there are N or more frames in the write-ahead log file.
R-26993-43540-10992-37102-45404-55683-60247-30594 tcl slt th3 src
Passing zero or a negative value as the nFrame parameter disables automatic checkpoints entirely.
/* IMP: R-26993-43540 */
# EVIDENCE-OF: R-26993-43540 Passing zero or a negative value as the # nFrame parameter disables automatic checkpoints entirely.
R-10203-42688-05745-20246-57567-01031-33670-42087 tcl slt th3 src
The callback registered by this function replaces any existing callback registered using sqlite3_wal_hook().
/* IMP: R-10203-42688 */
# EVIDENCE-OF: R-10203-42688 The callback registered by this function # replaces any existing callback registered using sqlite3_wal_hook().
R-17497-43474-02755-40707-55508-06941-43855-44277 tcl slt th3 src
Likewise, registering a callback using sqlite3_wal_hook() disables the automatic checkpoint mechanism configured by this function.
/* IMP: R-17497-43474 */
# EVIDENCE-OF: R-17497-43474 Likewise, registering a callback using # sqlite3_wal_hook() disables the automatic checkpoint mechanism # configured by this function.
R-30135-06439-12622-19657-03902-02051-33050-20191 tcl slt th3 src
The wal_autocheckpoint pragma can be used to invoke this interface from SQL.
/* IMP: R-30135-06439 */
# EVIDENCE-OF: R-30135-06439 The wal_autocheckpoint pragma can be used # to invoke this interface from SQL.
R-33080-59193-42664-27310-42541-31106-33090-39782 tcl slt th3 src
Checkpoints initiated by this mechanism are PASSIVE.
/* IMP: R-33080-59193 */
# EVIDENCE-OF: R-33080-59193 Checkpoints initiated by this mechanism are # PASSIVE.
R-41531-51083-45051-37425-19674-01432-09098-10672 tcl slt th3 src
Every new database connection defaults to having the auto-checkpoint enabled with a threshold of 1000 or SQLITE_DEFAULT_WAL_AUTOCHECKPOINT pages.
/* IMP: R-41531-51083 */
# EVIDENCE-OF: R-41531-51083 Every new database connection defaults to # having the auto-checkpoint enabled with a threshold of 1000 or # SQLITE_DEFAULT_WAL_AUTOCHECKPOINT pages.