DataTables with Large DataSet

tinac99

Hello,

I'm trying to improve the rendering of a datatable page for a search that returns a large result set.
I referred to these url links:
https://datatables.net/forums/discussion/8789/tips-for-using-datatables-with-very-large-data-sets
http://legacy.datatables.net/usage/server-side
https://www.datatables.net/release-datatables/examples/server_side/custom_vars.html

The results do come back after more than 5 seconds. But's there's this error...

DataTables warning: Ajax error. For more information about this error, please see http://datatables.net/tn/7.

This is the code(.net - MVC):

@if (Model.resultMasterTransactions != null)
{

@foreach (MasterTransactionsResultReportViewModel item in Model.resultMasterTransactions) { }

Material Code	Property Id	UOM	Issue Reason	Quantity
@item.MaterialCode	@item.PropertyId	@item.UOM	@item.IssueReason	@item.Quantity

}

@section Scripts {

$(document).ready(function () { var GridView = $('#tableResults').DataTable({ "iDisplayLength": 50, "processing": true, "ServerSide": true, "ajax": { "url": "reports/@Model.SearchAction", "type": "POST", }, dom: 'Bfrtip', buttons: [ 'copy', 'csv', 'excel', 'print' ] }); });

Is there anything I'm missing?

Thanks,

tinac99

kthorngren

The first step is to follow the troubleshooting steps provide at the link in the error:
http://datatables.net/tn/7

Let us know what you find.

Kevin