Datatables expert required - AJAX/performance
- or -
Post a project like this2395
$$$
- Posted:
- Proposals: 11
- Remote
- #1704991
- Awarded
** Top 5% ** - .NET | NodeJS | PHP | Shopify | NopCommerce | QA (Manual & Automation) | SEO & Marketing
Buncrana
18 years expert in PHP, MySQL, HTML, CSS, JavaScript, jQuery, Ajax, Bootstrap, Chrome Extension, VB, VBA, AutIT Programming & Website Data Scraping
Ambala
AI & Data Science Engineer | Nodejs | Ruby On Rails | AWS | GCP | Python | React | Angular |
Auckland
222962232476355601455855934674107587210886811100176161243117449751781088
Description
Experience Level: Expert
Estimated project duration: less than 1 week
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
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
Jason D.
100% (67)Projects Completed
113
Freelancers worked with
97
Projects awarded
33%
Last project
19 Nov 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
If you want AJAX pagination in Datatables (a product I've used extensively) then you need to apply the pagination on the server-side. Will you also be able to provide the server-side (PHP?) code which produces the JSON stream?
-
Can you share that JSON stream and the HTML/JS for us?
-
Is there any other feature need to implement other than data display, sort, search, pagination? I would like to know how many pages are in application?
498181497484497438
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies