Compare and test the paging mechanism of Php + MySql. Hardware environment: PIII550, 128 M, 15.2G software environment: Win98 + Apache + Php4 + MySql Solution 1: 1. use Selectcount (1) fromtabwherecondition for the first query to obtain the number of records meeting the conditions $ hardware environment: PIII550, 128 M, 15.2G
Software Environment: Win98 + Apache + Php4 + MySql
Solution 1:
1. use Select count (1) from tab where condition for the first query to obtain the number of records meeting the condition $ rows
2. use the first page $ page to retrieve the record set per page $ rpp
Select * from tab where condition limit ($ page-1) * $ rpp, $ rpp
3. display all records of the returned record set.
4. transfer $ rows to a later page during page transfer.
Solution 2:
1. retrieve records that meet the conditions
Select * from tab where condition
2. move the pointer to ($ page-1) * $ rpp
3. Display $ rpp records
======================= ============================================= ==+ =========
Number of records | scheme | times 1 2 3 4 5 6 7 8 9 0 | average | Efficiency ratio
======================= ============================================= ==+ =========
| Page 1 2, 1, 1, 2, 1, 1, 2, 2, 1, 2 | 1.3 |
| 1 + ---------------------------------------------- + ------ + 1.6 |
10000 records | other pages 2, 2, 2, 3, 1, 1, 2, 2, 2 | 1.9 | 4.8125
Ghost software environment: Win98 + Apache + Php4 + MySql Solution 1: 1. use Select count (1) from tab where condition for the first query to obtain the number of records meeting the conditions $...
