Set busy timeout

Original article title: Set a busy timeout

 

Int sqlite3_busy_timeout (sqlite3 *, int MS );

This function sets a "Database busy processing object". When the table to be accessed is locked, the processing object will wait for the specified time and time out. This processing object will sleep multiple times until the cumulative sleep reaches or exceeds Ms milliseconds. When it reaches or exceeds, the processing object returns 0, so that the sqlite3_step () function returns sqlite_busy or sqlite_ioerr_blocked.

Passing a parameter smaller than or equal to 0 to this function will close all busy processing objects in the database.

At one time point of a database connection, only one busy object can be processed by the database. If the busy processing object is set by calling other functions before the setting, the previous setting will be cleared.