tablesorter插件分页
我正在使用 tablesorter jquery 插件来处理带有数据库结果的表。但是，我有超过 10,000 行要加载，当表加载时，它会一次加载所有 10,000 行，然后将结果分页为每页 10,20,30,40 个结果。有什么方法可以阻止所有这些一次性加载或加载前 100 个等。
我已阅读过此论坛，但尚未提出此问题。请不要误会，我在显示每页结果数（10,20,30,40 等）时没有遇到问题，这是在第一次加载时实际加载行，因为我有一个包含 10,000 行的巨大数据库。
感谢您抽出时间。
I am using the tablesorter jquery plugin for my table with database results. However, I have more than 10,000 rows to load and when the table loads it loads all 10,000 at once and then paginates the results into 10,20,30,40 results per page. Is there any way to prevent all of them loading at once or load the first 100 etc.
I have read around this forum and this question has not been asked. Please do not be mistaken I am not having trouble with displaying the number of results per page (10,20,30,40 etc.) this is with actually loading the rows on first load since I have a huge database of 10,000 rows.
Thanks for your time.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我认为您想要的是一次加载 10 行，然后每次更改页面时加载接下来的 10 行，对吗？
如果是这样，我建议查看 jqGrid。它具有许多内置功能，包括分页、排序和异步服务器调用。
I think what you want is to load 10 rows at a time and then every time you change the page, load the next 10, is that correct?
If so, I suggest looking into the jqGrid. It has many of these features built in including paging, sorting, and asynchronous sever calls.