/
PHP中的数据库连接持久化.php
45 lines (39 loc) · 1.28 KB
/
PHP中的数据库连接持久化.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
<?php
$db = [
'server' => 'localhost:3306',
'user' => 'root',
'password' => '',
'database' => 'blog_test',
];
$startTime = getmicrotime();
for ($i = 0; $i < 1000; $i++) {
$mysqli = new mysqli($db["server"], $db["user"], $db["password"], $db["database"]); //持久连接
$mysqli->close();
}
echo bcsub(getmicrotime(), $startTime, 10), PHP_EOL;
// 6.5814000000
$mysqli = null;
$startTime = getmicrotime();
for ($i = 0; $i < 1000; $i++) {
$mysqli = new mysqli('p:' . $db["server"], $db["user"], $db["password"], $db["database"]); //持久连接
$mysqli->close();
}
echo bcsub(getmicrotime(), $startTime, 10), PHP_EOL;
// 0.0965000000
$startTime = getmicrotime();
for ($i = 0; $i < 1000; $i++) {
$pdo = new PDO("mysql:dbname={$db['database']};host={$db['server']}", $db['user'], $db['password']);
}
echo bcsub(getmicrotime(), $startTime, 10), PHP_EOL;
// 6.6171000000
$startTime = getmicrotime();
for ($i = 0; $i < 1000; $i++) {
$pdo = new PDO("mysql:dbname={$db['database']};host={$db['server']}", $db['user'], $db['password'], [PDO::ATTR_PERSISTENT => true]); //持久连接
}
echo bcsub(getmicrotime(), $startTime, 10), PHP_EOL;
// 0.0398000000
function getmicrotime()
{
list($usec, $sec) = explode(" ", microtime());
return ((float) $usec + (float) $sec);
}