Small. Fast. Reliable.
Choose any three.

SQLite C Interface

Set A Busy Timeout

int sqlite3_busy_timeout(sqlite3*, int ms);

R-42315-53658:[This routine sets a busy handler that sleeps for a specified amount of time when a table is locked. ] R-60235-46489:[The handler will sleep multiple times until at least "ms" milliseconds of sleeping have accumulated. ] R-23828-03043:[After at least "ms" milliseconds of sleeping, the handler returns 0 which causes sqlite3_step() to return SQLITE_BUSY. ]

R-64470-55820:[Calling this routine with an argument less than or equal to zero turns off all busy handlers. ]

R-42556-20460:[There can only be a single busy handler for a particular database connection at any given moment. If another busy handler was defined (using sqlite3_busy_handler()) prior to calling this routine, that other busy handler is cleared. ]

See also: PRAGMA busy_timeout

See also lists of Objects, Constants, and Functions.