mysql和redis用于网站活跃度_mysql和redis效率问题

$redis = new redis();

$redis->connect('127.0.0.1', 6379);

for ($i=0; $i <100 ; $i++) {

$redis->lpush('test',rand(1000,9999));

}

var_dump($redis->lrange('test', 0, 99));

$redis->delete('test');

$redis->close();

die;

?>

=================================

$host = 'mysql:host=127.0.0.1;dbname=test';

$user = 'root';

$pass = 'root';

$pdo = new PDO($host, $user, $pass);

for ($i=0; $i < 100 ; $i++) {

$pdo->query('insert into abc (title) values( title = '.rand(1000,9999).')');

}

var_dump($pdo->query('select * from abc')->fetch());

$pdo->query('truncate table abc');

die;

?>

使用ab压力测试

ab -n10000 -c10000 http://localhost/test.php

二者测试结果接近，MYSQL略优，但是如果直接运行以下代码

$redis = new redis();

$redis->connect('127.0.0.1', 6379);

for ($i=0; $i <10000 ; $i++) {

$redis->lpush('test',rand(1000,9999));

}

var_dump($redis->lrange('test', 0, 9999));

$redis->delete('test');

$redis->close();

die;

?>

=================================

$host = 'mysql:host=127.0.0.1;dbname=test';

$user = 'root';

$pass = 'root';

$pdo = new PDO($host, $user, $pass);

for ($i=0; $i < 10000 ; $i++) {

$pdo->query('insert into abc (title) values( title = '.rand(1000,9999).')');

}

var_dump($pdo->query('select * from abc')->fetch());

$pdo->query('truncate table abc');

die;

?>

mysql耗费的时间是redis的100多倍，这是为什么？是和连接数有关吗