Load time on datatables
We are a devt team and want to build a new solution so we decided to try the loading time of the data tables of the newest version. For this we decided to do some tests as follows:
We used core PHP to echo out a table containing 500,000 records with 6 attributes.
#1. When we use plain tables with no table class, we get all data loading in 1 minute, 27 seconds.
#2. When we use introduce the class that shows search, sorting, pagination, we got 40 minutes.
If you are working with a large database, you may want to consider using the server-side option provided by DataTables.
With server-side processing enabled, all actions that DataTables perform (such as paging, searching, and ordering) are submitted to a server where a SQL engine (or similar) can perform these actions on large datasets.
Therefore, each table draw will result in a new Ajax request to retrieve the required data.
How do I turn it on? I didn't find the documents in version 8 vuejs.
Hi Artem Sib,
For vue, please create another support question with the vue tag. Vue has a different datatable from the datatable in PHP.