The efficiency of reading and writing files and reading and writing databases in PHP_PHP Tutorial

This article will introduce to you a comparison of the efficiency of reading and writing files and reading and writing databases in PHP. Friends who need to know more can refer to it.

The test program is as follows:

//Explanation 1: Since the read database statement calls the simple packet function twice, the read file is also changed to be called twice consecutively. The database record ID is 1 in the first One, and unique index.

The code is as follows

Copy code

代码如下

复制代码

//说明2：测试两次一次是4K数据，一次是整形数据 set_time_limit(0); function fnGet($filename) {     $content = file_get_contents($filename);     return $content; } function fnGetContent($filename) {     $content = fnGet($filename);     return $content; }     $times=100000;    echo '数据库查询结果： '; //--------------------------------- $begin=fnGetMicroTime(); for($i=0;$i<$times;$i++) { $res=$dbcon->mydb_query("SELECT log_Content FROM blog WHERE log_ID='1'");     $row=$dbcon->mydb_fetch_row($res);     $content=$row[0]; } echo 'fetch_row '.$times.' 次时间：'.(fnGetMicroTime()-$begin).'秒 '; //--------------------------------- $begin=fnGetMicroTime(); for($i=0;$i<$times;$i++) { $res=$dbcon->mydb_query("SELECT log_Content FROM blog WHERE log_ID='1'");     $row=$dbcon->mydb_fetch_array($res);     $content=$row['log_Content'];    } echo 'fetch_array '.$times.' 次时间：'.(fnGetMicroTime()-$begin).'秒 '; //--------------------------------- $begin=fnGetMicroTime(); for($i=0;$i<$times;$i++) { $res=$dbcon->mydb_query("SELECT log_Content FROM blog WHERE log_ID='1'");     $row=$dbcon->mydb_fetch_object($res);     $content=$row->log_Content;    } echo 'fetch_object '.$times.' 次时间：'.(fnGetMicroTime()-$begin).'秒 '; //--------------------------------- $dbcon->mydb_free_results(); $dbcon->mydb_disconnect(); fnWriteCache('test.txt',$content); echo '直接读文件测试结果： '; //--------------------------------- $begin=fnGetMicroTime(); for($i=0;$i<$times;$i++) {     $content = fnGetContent('test.txt'); } echo 'file_get_contents直接读'.$times.'次时间：'.(fnGetMicroTime()-$begin).'秒 '; //--------------------------------- $begin=fnGetMicroTime(); for($i=0;$i<$times;$i++) {     $fname = 'test.txt';     if(file_exists($fname))      {         $fp=fopen($fname,"r");//flock($fp,LOCK_EX);                $file_data=fread($fp, filesize($fname));//rewind($fp);               fclose($fp);     }     $content = fnGetContent('test.txt'); }    echo 'fopen直接读'.$times.'次时间：'.(fnGetMicroTime()-$begin).'秒 ';

//Explanation 2: Test twice, once with 4K data and once with integer dataset_time_limit(0);function fnGet($filename)
{
$content = file_get_contents($filename);
return $content;
}function fnGetContent($filename)
{
$content = fnGet($filename);
return $content;
}

$times=100000;
echo 'Database query results:
';
//--------------------------------
$begin =fnGetMicroTime();
for($i=0;$i<$times;$i++)
{
$res=$dbcon->mydb_query("SELECT log_Content FROM blog WHERE log_ID='1'");
$row=$dbcon->mydb_fetch_row($res);
$content=$row[0];
}
echo ' fetch_row '.$times.' times: '.(fnGetMicroTime()-$begin).'seconds
';
//- --------------------------------$begin=fnGetMicroTime();
for ($i=0;$i<$times;$i++)
{
$res=$dbcon->mydb_query("SELECT log_Content FROM blog WHERE log_ID='1'");
$row=$dbcon->mydb_fetch_array($res);
$content=$row['log_Content'];
}
echo 'fetch_array '.$times.' times Time: '.(fnGetMicroTime()-$begin).'Seconds
';
//--------- --------------------------$begin=fnGetMicroTime();
for($i=0;$i< ;$times;$i++)
{
$res=$dbcon->mydb_query("SELECT log_Content FROM blog WHERE log_ID='1'");
$row=$dbcon- >mydb_fetch_object($res);
$content=$row->log_Content;
}
echo 'fetch_object '.$times.' times: '.(fnGetMicroTime()-$begin).'seconds
';
//------------------ ---------------$dbcon->mydb_free_results();
$dbcon->mydb_disconnect();fnWriteCache ('test.txt',$content);echo 'Directly read the file test results:
';//--------- --------------------------
$begin=fnGetMicroTime();
for($i=0;$i<$ times;$i++)
{
$content = fnGetContent('test.txt');
}
echo 'file_get_contents read directly'.$times.' times: < ;font color=red>'.(fnGetMicroTime()-$begin).'seconds
';
//------------ ---------------------$begin=fnGetMicroTime();
for($i=0;$i<$times ;$i++)
{
$fname = 'test.txt';
if(file_exists($fname))
{
$fp=fopen($fname , "r");//flock($fp,LOCK_EX); fp);
}
$content = fnGetContent('test.txt');
}
echo 'fopen reads directly '.$times.' times: '.(fnGetMicroTime()-$begin).'seconds
';

Query results for 4K size data:

fetch_row 100000 times: 16.737720012665 ​​seconds

fetch_array 100000 times: 16.661195993423 seconds

fetch_object 100000 times Time: 16.775065898895 seconds

Direct file reading test results:

file_get_contents direct reading 100000 times time: 5.4631857872009 seconds

fopen direct reading 100000 times time: 11.463611125946 seconds

Plastic ID query Result:

fetch_row 100000 times time: 12.812072038651 seconds

fetch_array 100000 times time: 12.667390108109 seconds

fetch_object 100000 times time: 12.9880990 98206 seconds

Read the file directly Test results:

File_get_contents read directly 100000 times time: 5.6616430282593 seconds

fopen read directly 100000 times time: 11.542816877365 seconds

Test conclusion:

1. Reading files directly is more efficient than database query, and the connection and disconnection time is not included in the article.

2. The larger the content read at one time, the more obvious the advantage of reading files directly (the time to read files increases slightly, which is related to the continuity of file storage and cluster size). This result It is exactly the opposite of what Tianyuan expected, indicating that MYSQL may have additional operations for reading larger files (the time increased by nearly 30% twice). If it is just a simple assignment conversion, the difference should be small.

3. Writing files and INSERT can be inferred with almost no testing, and the database efficiency will only get worse.

4. If a small configuration file does not need to use database features, it is more suitable to be stored in a separate file for access. There is no need to create a separate data table or record. Large files such as pictures, music, etc. use files. Storage is more convenient, and it is more reasonable to only put index information such as paths or thumbnails in the database.

5. If you only read files on PHP, file_get_contents is more efficient than fopen and fclose. Excluding the time required to determine the existence of this function, it will take about 3 seconds less.

6. fetch_row and fetch_object should be converted from fetch_array. Tianyuan has not seen the source code of PHP. From the execution alone, it can be seen that fetch_array is more efficient. This seems to be contrary to what is said on the Internet.

http://www.bkjia.com/PHPjc/444607.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/444607.htmlTechArticleThis article will introduce to you a comparison of the efficiency of reading and writing files and reading and writing databases in php. If you need to know more Friends can refer to it. The test program is as follows: //Note 1: Due to the language of reading the database...