php - jQuery DataTables 是在单个请求中还是使用分页从数据库中获取所有数据？

Question

有人请帮助我 我正在使用 Bootstrap 数据表。我想知道 datatable 在单个请求中从 mysql 获取所有数据或使用分页来获取数据。

Answer 1

来自 official documentation :

DataTables has two different modes of processing data (ordering, searching, etc. of data):

• Client-side processing - the full data set is loaded up-front and data processing is done in the browser.
• Server-side processing - an Ajax request is made for every table redraw, with only the data required for each display returned. The data processing is performed on the server.

您可以根据数据量和您的项目需求使用其中任何一种。