小草blog : http://homeway.me/

The artile is about a php module for mysql

It likes codeigniter,but has some other feature.

And then, I test It`s speed.

Fork me here: https://github.com/grasses/JueQuery

0x01.System Environment

- system
MAC os
Software
OS X 10.9.4 (13E28)
Processor
2.4 GHz Intel Core i5
Memory
8 GB 1600 MHz DDR3
250GB SSD
- environment
xampp 1.8.3
Apache/2.4.9
PHP Version 5.5.11
mysqlnd 5.0.11-dev - 20120503 - (mysql is empty)

0x02.Test Insert

Code is here

$jue = new JueQuery();
for($i=0; $i<100; $i++){
$insert_data = array(
'email'=>'xiaocao.grasses@gmail.com',
'username'=>'http://homeway.me/',
"password"=>md5( rand().time() ),
);
$insert_test = $jue->insert_where('user', $insert_data );
}

First test result

Second test result

Third test result

And then mysql is like this:

0x03.Select a data does not exist in 30000 pieces data

Code is here

for($i=0; $i<100; $i++){
$single = true;
$where = array(
'username'=>'http://homeway.me/',
'password'=>'6f27e19bbdd4f290038149344fcc5ffd',
);
$select_test = $jue->select('id|username|email')->order_by('id', 'ASC')->get_where('user', $where,$single);
$jue->debug('Select Test', $select_test);
}

Test result is here:

0x04.Select a data exist in 30000 pieces data

Test result is here:

Ox05.Select a data exist in 30000 pieces data using normal function without class

Code is here

for ($i=1; $i < 100 ; $i++) {
$select = "SELECT * FROM `user` WHERE `password` = 'd29a75d265e91f0de0342443eb2731b5'";
$select_result = mysql_query($select);
}

Test result is here:

From result we know that, run class and function, only using 10 seconds in 10000 fetch, so class is efficiention

0x06.Update 30000 in 30000 pieces of data

Code is here:

for($i=0; $i<100; $i++){
$where = array(
'id'=>$i,
);
$set = array(
'username'=>'http://homeway.me/',
'email'=>'xiaocao.grasses@gmail.com',
);
$update_test = $jue->update_where('user', $where, $set);
}

Test result is here:

Please indicate the source:http://homeway.me/2014/09/19/PHP-Module-Mysql/

-By xiaocao

2014-09-19 19:16:45

最后

以上就是机智蛋挞为你收集整理的mysql的速度测试0x01.System Environment0x02.Test Insert0x03.Select a data does not exist in 30000 pieces data0x04.Select a data exist in 30000 pieces dataOx05.Select a data exist in 30000 pieces data using normal function without class0x06.Update 30000 in 的全部内容，希望文章能够帮你解决mysql的速度测试0x01.System Environment0x02.Test Insert0x03.Select a data does not exist in 30000 pieces data0x04.Select a data exist in 30000 pieces dataOx05.Select a data exist in 30000 pieces data using normal function without class0x06.Update 30000 in 所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。