How to optimize the sampling of a large amount of data?

Question

PHP

One of the MySQL database tables has a large amount of data (more than 35,000 records). Querying all data from a table takes a significant amount of time. Is there a way to quickly get all the data from a given table?
Explain tables:

Answer 1

https://datatables.net/
Example in https://datatables.net/manual/server-side
Parameters startand lengthdetermine how the server should receive a selection from the DBMS.