The efficiency of reading and writing files and reading and writing databases in PHP

Home

Backend Development

PHP Tutorial

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jul 20, 2016 am 11:11 AM

php and introduce about efficiency database document article of Read and write

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.

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Grow A Garden - Complete Mutation Guide

3 weeks ago By DDD

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

How to fix KB5055612 fails to install in Windows 10?

3 weeks ago By DDD

Nordhold: Fusion System, Explained

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial

1664

CakePHP Tutorial

1423

Laravel Tutorial

1321

PHP Tutorial

1269

C# Tutorial

1249

Related knowledge

PHP in Action: Real-World Examples and Applications Apr 14, 2025 am 12:19 AM

PHP is widely used in e-commerce, content management systems and API development. 1) E-commerce: used for shopping cart function and payment processing. 2) Content management system: used for dynamic content generation and user management. 3) API development: used for RESTful API development and API security. Through performance optimization and best practices, the efficiency and maintainability of PHP applications are improved.

PHP and Python: Code Examples and Comparison Apr 15, 2025 am 12:07 AM

PHP and Python have their own advantages and disadvantages, and the choice depends on project needs and personal preferences. 1.PHP is suitable for rapid development and maintenance of large-scale web applications. 2. Python dominates the field of data science and machine learning.

PHP and Python: Different Paradigms Explained Apr 18, 2025 am 12:26 AM

PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.

PHP: Handling Databases and Server-Side Logic Apr 15, 2025 am 12:15 AM

PHP uses MySQLi and PDO extensions to interact in database operations and server-side logic processing, and processes server-side logic through functions such as session management. 1) Use MySQLi or PDO to connect to the database and execute SQL queries. 2) Handle HTTP requests and user status through session management and other functions. 3) Use transactions to ensure the atomicity of database operations. 4) Prevent SQL injection, use exception handling and closing connections for debugging. 5) Optimize performance through indexing and cache, write highly readable code and perform error handling.

PHP's Purpose: Building Dynamic Websites Apr 15, 2025 am 12:18 AM

PHP is used to build dynamic websites, and its core functions include: 1. Generate dynamic content and generate web pages in real time by connecting with the database; 2. Process user interaction and form submissions, verify inputs and respond to operations; 3. Manage sessions and user authentication to provide a personalized experience; 4. Optimize performance and follow best practices to improve website efficiency and security.

Choosing Between PHP and Python: A Guide Apr 18, 2025 am 12:24 AM

PHP is suitable for web development and rapid prototyping, and Python is suitable for data science and machine learning. 1.PHP is used for dynamic web development, with simple syntax and suitable for rapid development. 2. Python has concise syntax, is suitable for multiple fields, and has a strong library ecosystem.

PHP and Python: A Deep Dive into Their History Apr 18, 2025 am 12:25 AM

PHP originated in 1994 and was developed by RasmusLerdorf. It was originally used to track website visitors and gradually evolved into a server-side scripting language and was widely used in web development. Python was developed by Guidovan Rossum in the late 1980s and was first released in 1991. It emphasizes code readability and simplicity, and is suitable for scientific computing, data analysis and other fields.

Why Use PHP? Advantages and Benefits Explained Apr 16, 2025 am 12:16 AM

The core benefits of PHP include ease of learning, strong web development support, rich libraries and frameworks, high performance and scalability, cross-platform compatibility, and cost-effectiveness. 1) Easy to learn and use, suitable for beginners; 2) Good integration with web servers and supports multiple databases; 3) Have powerful frameworks such as Laravel; 4) High performance can be achieved through optimization; 5) Support multiple operating systems; 6) Open source to reduce development costs.

See all articles