Web开发-SQL创建最近的页面

Question

I'm creating a web application where one of the features will include getting the recent games played. I want to make it so the 25 most recent games played will be on the first page, with a page selection at the bottom. (Games data will be grabbed from MYSQL)

I understand this is a concept many sites already have, but after extensive googling I'm uncertain of a way to efficiently do this. The only thing I can currently think of is querying every game of theirs then splitting it into pages, but wouldn't that become extremely inefficient when it gets in the thousands?

Any help, or link to outside sources that explain this topic would be greatly appreciated, thank you!

Answer 1

For pagination use limit:

The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement.

... the first argument specifies the [zero origin] offset of the first row to return, and the second specifies the maximum number of rows to return. ...

SELECT * FROM tbl LIMIT 5,10; # Retrieve rows 6-15

So for the first page it's enough to request all games played, order by time_played DESCending, limit 25. Just be sure to put an index on the time_played column.