JavaScript Editor Javascript debugger     Website design 


Set busy timeout duration, or disable busy handlers (PHP 5, PECL sqlite:1.0-1.0.3)
void sqlite_busy_timeout ( resource dbhandle, int milliseconds )

Object oriented style (method):

SQLiteDatabase {
  void busyTimeout(int milliseconds);

Set the maximum time, in milliseconds, that SQLite will wait for a dbhandle to become ready for use.



The SQLite Database resource; returned from sqlite_open() when used procedurally. This parameter is not required when using the object-oriented method.


The number of milliseconds. When set to 0, busy handlers will be disabled and SQLite will return immediately with a SQLITE_BUSY status code if another process/thread has the database locked for an update.

PHP sets the default busy timeout to be 60 seconds when the database is opened.


There are one thousand (1000) milliseconds in one second.

Return Values

No value is returned.


Example 2318. Procedural style

= sqlite_open('sqlitedb');
sqlite_busy_timeout($dbhandle, 10000); // set timeout to 10 seconds
sqlite_busy_timeout($dbhandle, 0); // disable busy handler

Example 2319. Object oriented style

= new SQLiteDatabase('sqlitedb');
$dbhandle->busyTimeout(10000); // 10 seconds
$dbhandle->busyTimeout(0); // disable