What is the difference between yii2 batch and each
Our database is often very large, and the result set of a query is also very large, which wastes memory. In order to reduce memory usage, we can use yii2's batch and each method.
In order to let everyone see more clearly, we simulate a scenario, and then use the debug of yii2 to view the memory usage under the all and batch/each methods.
Start preparation
We first create a table, it is very simple.
You see, it has the primary key id, member name username, and province. Now it is empty.
Then, we executed a loop
set_time_limit(0);
for($i=1;$i<=10000;$i++){
Yii::$app->db->createCommand()->insert("user",[
'username'=>'abei'.$i,
'province'=>'北京市'
])->execute();
}After execution, you know that there are 10,000 records in our database, and now we start to compare.
Comparison
For convenience, we write the loop body directly in the view, such as the following code, you can definitely understand it.
$query = new \yii\db\Query();
$query->from('user');
foreach($query->all() as $user){
echo $user['username'];
echo "<br/>";
}The result?
Occupied memory 15.306MB
OK, now let’s see if the tricks of batch and each save memory.
$query = new \yii\db\Query();
$query->from('user');
foreach($query->batch() as $users){
foreach($users as $user){
echo $user['username'];
echo "<br/>";
}
}The result?
# Sure enough, half of the memory was saved. Now it only takes up 8.077MB
The same
$query = new \yii\db\Query();
$query->from('user');
foreach($query->each() as $user){
echo $user['username'];
echo "<br/>";
}each performance is also quite good
Result
When we need to read all or a large batch of data at once, we can consider using batch and each. This little bit of code optimization can help you save half of the memory.
PHP Chinese website has a large number of free Yii introductory tutorials, everyone is welcome to learn!
The above is the detailed content of What is the difference between yii2 batch and each. For more information, please follow other related articles on the PHP Chinese website!
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
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
1663
14
1420
52
1315
25
1266
29
1239
24
How to set password protection for export PDF on PS
Apr 06, 2025 pm 04:45 PM
Export password-protected PDF in Photoshop: Open the image file. Click "File"> "Export"> "Export as PDF". Set the "Security" option and enter the same password twice. Click "Export" to generate a PDF file.
The difference between H5 and mini-programs and APPs
Apr 06, 2025 am 10:42 AM
H5. The main difference between mini programs and APP is: technical architecture: H5 is based on web technology, and mini programs and APP are independent applications. Experience and functions: H5 is light and easy to use, with limited functions; mini programs are lightweight and have good interactiveness; APPs are powerful and have smooth experience. Compatibility: H5 is cross-platform compatible, applets and APPs are restricted by the platform. Development cost: H5 has low development cost, medium mini programs, and highest APP. Applicable scenarios: H5 is suitable for information display, applets are suitable for lightweight applications, and APPs are suitable for complex functions.
Why do you need to call Vue.use(VueRouter) in the index.js file under the router folder?
Apr 05, 2025 pm 01:03 PM
The necessity of registering VueRouter in the index.js file under the router folder When developing Vue applications, you often encounter problems with routing configuration. Special...
Difference between centos and ubuntu
Apr 14, 2025 pm 09:09 PM
The key differences between CentOS and Ubuntu are: origin (CentOS originates from Red Hat, for enterprises; Ubuntu originates from Debian, for individuals), package management (CentOS uses yum, focusing on stability; Ubuntu uses apt, for high update frequency), support cycle (CentOS provides 10 years of support, Ubuntu provides 5 years of LTS support), community support (CentOS focuses on stability, Ubuntu provides a wide range of tutorials and documents), uses (CentOS is biased towards servers, Ubuntu is suitable for servers and desktops), other differences include installation simplicity (CentOS is thin)
How to use XPath to search from a specified DOM node in JavaScript?
Apr 04, 2025 pm 11:15 PM
Detailed explanation of XPath search method under DOM nodes In JavaScript, we often need to find specific nodes from the DOM tree based on XPath expressions. If you need to...
What is the difference between syntax for adding columns in different database systems
Apr 09, 2025 pm 02:15 PM
不同数据库系统添加列的语法为：MySQL：ALTER TABLE table_name ADD column_name data_type;PostgreSQL：ALTER TABLE table_name ADD COLUMN column_name data_type;Oracle：ALTER TABLE table_name ADD (column_name data_type);SQL Server：ALTER TABLE table_name ADD column_name data_
What are the different ways of promoting H5 and mini programs?
Apr 06, 2025 am 11:03 AM
There are differences in the promotion methods of H5 and mini programs: platform dependence: H5 depends on the browser, and mini programs rely on specific platforms (such as WeChat). User experience: The H5 experience is poor, and the mini program provides a smooth experience similar to native applications. Communication method: H5 is spread through links, and mini programs are shared or searched through the platform. H5 promotion methods: social sharing, email marketing, QR code, SEO, paid advertising. Mini program promotion methods: platform promotion, social sharing, offline promotion, ASO, cooperation with other platforms.
The difference between laravel and thinkphp
Apr 18, 2025 pm 01:09 PM
Laravel and ThinkPHP are both popular PHP frameworks and have their own advantages and disadvantages in development. This article will compare the two in depth, highlighting their architecture, features, and performance differences to help developers make informed choices based on their specific project needs.
