Search

Start with this FAQ to get an idea of optoins to increase the speed. You are fetching the data then populating n HTML table then initializing Datatables which also reads/processes all the rows in th…

<div> </div> <div> <table id="mydatatable"> <thead> <tr> <th> </th> <th> </th&g

Sounds like you will need to use Server Side Processing to handle paging of the data. You will need a server script to support the Server Side Processing Protocol. Datatables provides some SSP scri…

"search_location": $("#search_location").val(), "search_event_type": $("#search_event_type").val(),

error snap.

To enable server side paging with Datatables you will need to enable server side processing. Datatables provides some open source server side libraries you can use. This blog describes using these …

This FAQ provides the options to help increase loading speed.

I'm not familiar with the language in your first code snippet so won't be able to help there. Someone else might have some ideas. In general you will need to follow the server code to see what is d…

Combine them into one settings object as described in the Options manual.

In addition to looking at the server logs that Colin mentioned (which you need to fix first) your JSON data example does not conform to the expected server side processing protocol. You don't need t…

This section of the FAQ should help, it discusses various techniques to improve performance,

$(document).ready(function (e, row) { $("#Sector_PoliceStation_LocationWiseReport").DataTable( { "processing": true, "serve

The problem is that once the 20,000 rows are rendered into the DOM then Datatables needs to process the 20,000 rows to build its data cache and setup the table. So it will be slow. To improve the s…

I have tried to modify the options orderClasses, scrollX and scrollY (from the help: https://datatables.net/faqs/index#speed), without any success.

I count six different initialisations of DataTables there. Each with different parameters.

{ $('#sidebar2').removeClass('active'); $('html').css('overflow','auto'); $('.overla

https://datatables.net/manual/tech-notes/9#Server-side-processing

} }); // Multi Selection Datatable $('#selection-datatable').DataTable({ select: { style: 'multi' }, "language": { "paginate": { "

See this FAQ.

$("#searchInput").change(function(){ var searchValue = document.getElementById("searchInput").value; table.rows(':contains("'+searchValue+'")').select(); docu