Re: Adding data table plugin to improve tables

Posted by fiammybe on 1552149272

Datatables integration would be great, so please do a PR for 2.0 once you have something that works

The problem that you are experiencing is that the data is managed in 2 worlds : the javascript world and the PHP world. The javascript world (datatables.js) works with the data that you give it. In a simple situation, the basic configuration of datatables works fine : you feed it all the data, and everything is managed inside the datatables implementation, on the client browser.

As you found out, that is limited to small datasets. Once you get into the few hundreds, the browser slows down considerably. The trick is to plugin PHP functionality to replace some of the functions that datatables does in the browser, and shift the workload as much as possible to the server. Sorting and such as well, because if you load only 15 elements inside of datatables, in its standard configuration, it will only work with those 15 lines, giving very funny results, that will be plain wrong

in my opinion, you will need to write an integration for the loading, updating, sorting, searching of data from datatables within ImpressCMS. Once you have that, the sky will be the limit


This Post was from: https://www.impresscms.org/iforum/viewtopic.php?topic_id=5862&post_id=50586