sqlite_busy_timeout
SQLiteDatabase::busyTimeout
(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0)
sqlite_busy_timeout -- SQLiteDatabase::busyTimeout — Set busy timeout duration, or disable busy handlers
설명
void sqlite_busy_timeout
( resource $dbhandle
, int $milliseconds
)
public void SQLiteDatabase::busyTimeout
( int $milliseconds
)
인수
-
dbhandle
-
The SQLite Database resource; returned from sqlite_open()
when used procedurally. This parameter is not required
when using the object-oriented method.
-
milliseconds
-
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.
Note:
There are one thousand (1000) milliseconds in one second.
예제
Example #1 절차식 형식
<?php
$dbhandle = sqlite_open('sqlitedb');
sqlite_busy_timeout($dbhandle, 10000); // set timeout to 10 seconds
sqlite_busy_timeout($dbhandle, 0); // disable busy handler
?>
Example #2 객체 기반 형식
<?php
$dbhandle = new SQLiteDatabase('sqlitedb');
$dbhandle->busyTimeout(10000); // 10 seconds
$dbhandle->busyTimeout(0); // disable
?>
참고
- sqlite_open() - Opens an SQLite database and create the database if it does not exist