It is generally faster to query 100 items at a time. Mainly to explain the sql statement, plan the query method, and the cost of index searching, etc. In addition, the difference between queries that do not use indexes and scan the table is more obvious. One scans from beginning to end to find all the data, and the other scans 100 times each time. Scan from the beginning...
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
It is generally faster to query 100 items at a time. Mainly to explain the sql statement, plan the query method, and the cost of index searching, etc. In addition, the difference between queries that do not use indexes and scan the table is more obvious. One scans from beginning to end to find all the data, and the other scans 100 times each time. Scan from the beginning...