Slow performance with server side large dataset
Slow performance with server side large dataset
sumit11123
Posts: 1Questions: 1Answers: 0
I am using DataTables 1.10.7 with asp.net c#,
I am using session to store the dataset and not repeatedly sending request to database server.
using server side paging with 100 k records.
i have used "deferRender": true also but even then while searching or paging the DataTables is using a 40 to 60 seconds to populate and rebind with 25 records resultset obtained from ajax as json.
I m using linq to get search data from session data which is not taking more then 1 seconds.
$('#requestTable').dataTable({
destroy: true,
stateSave: true,
"deferRender": true,
serverSide: true,
sDom: "lftip",
...... and then ajax section with (JSON) response etc.
}
It is working fine upto 1000 records.
Help me to sort out the issue please.....
Thanks in Advance.