小草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
**粗体** _斜体_ [链接](http://example.com) `代码` - 列表 > 引用
。你还可以使用@
来通知其他用户。