Paginate通过PHP与MySQL最佳实践？ [关闭]

Question

When dealing with records of at least 1 million rows, in terms of performance, is it better to:

Select the whole record e.g., SELECT * FROM tbl then paginate the result using array_chunk() or array_slice()

or

Select only part of the record e.g., SELECT * FROM tbl LIMIT x per page?

Answer 1

It is better to use LIMIT. think about it.. The first one will get all even if you have 1000000 rows. vs limit which will only get your set number each time.

You will then want to make sure you have your offsets set correctly to get the next set of items from the table.