Home >Backend Development >PHP Tutorial >mysql_num_rows VS COUNT efficiency problem analysis_PHP tutorial
mysql_num_rows VS COUNT efficiency problem analysis_PHP tutorial
- WBOYOriginal
- 2016-07-21 15:30:171238browse
Both mysql_num_rows and count(*) can count the total number, which one is better?
or
When to use num_rows and count( * ) respectively
An intuitive comparison
Test data:
Number of items: 139764
Data table size: 500M
Result:
fetch_num_rows time: 35.272329092026
count(*) time: 0.071956872940063
If the number is simply counted, of course it is count(*)
fetch_num_rows must be traversed through the database. The result is less efficient than count(*)
Statement：
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
Previous article：php code to get global variables_PHP tutorialNext article：php code to get global variables_PHP tutorial