Datatables expert required - AJAX/performance

We use Datatables 1.10 extensively in a web application - it works really well except in a few cases where there is a large volume of data and then it is really slow. Some tables with only 2000 rows can take 2 minutes to load.

We need someone to optimise DT to load via AJAX so the heavy lifting is done server side.

For Datatables we use quite a few add on modules. We use exporting, column selector, column re order, simple search (should search the whole dataset and not just what is on the page), dropdowns on column headers (these should load all options by AJAX and not just what is on the page), state save and responsive. The data loaded includes many joins so is quite complex - it gets pulled from MySQL.

We also have icons included in the last column which are hidden under a dropdown toggle. The contents of the dropdown can change based on who is viewing the table - each of these icons has an ID to link to another page to perform an action. Additionally some of the columns have HTML formatting in them - for example one column is for status and if it is passed then it shows passed in a green pill and if failed then failed in a red pill. Also depending on the customer chosen dateformat in the application then dates should be displayed with the correct dateformat which is generated by an existing PHP function.

We need to be able to take the current table and easily replicate it EXACTLY but loading via AJAX - everything should work the same as it does now including sorting, search (standard and also in column dropdown) and so on.

We will send you a JSON stream and the HTML/JS for the table and you will need to be able to then create this on your own demo environment - due to the nature of the data we process you will NOT be able to get access to actual live code and our servers etc