DataTables are very slow while fetching data through AJAX call from WebApi(Server).

NishantPatriker

HI,

I m observing extreme slowness while loading records from Ajax calls to the data tables in my views.
Here is the code for testing purpose that i have attained with ur debugger : "alimiw".
The datatables are taking time as much as 5 mins for loading 4000 records only.
I have already tried with below options :- nothing seems to work :
DeferredRender : True
ServerSide : True
Processing : True
Info : True
stateSave : True
Responsive : True (Removed).

Suggest me the changes that can improve my experience in loading records. I dont believe any thing can take that much time to load this less records.

Thanks in advance

Tom (DataTables)

Thanks for the debug trace but in this case it would be good to have a link to the page you are having the problem with.

If you have tried server side processing have you implemented it on the server side?

Thanks

Tom

NishantPatriker

server side is not the issue, whats the issue that i m observing is --

1] I am calling a webapi to get the data in the Datatable.
2] WebApi returns me the IHttpResult /HttpResponseMessage , most probably in XML..
3] If i try with Json in normal Mvc controller, the records are fetched pretty fast, but if i am trying with Json in IhttpResult or HttpResponseMessage , the RECORDS ARE TAKING MORE TIME TO LOAD.
4] I GUESS THE ISSUE IS WITH DATA TABLE IS NOT ABLE TO PROCESS THE RECORDS FASTER IF THE FORMAT IS NOT JSON.
5] CAN YOU PLEASE SUGGEST ME ANY WAY THROUGH WHICH I DONT HAVE TO RELY ON JSON ONLY AND MY RECORDS ARE FASTER TOO.