CODEWITHSUNDEEP
jquerydatatable
Newbizone
Newbizone

Reputation: 37

DataTable slow Loading of Data from Database

Hi guys need a help i need to load 10 thousand data from my database and here is my Data table code how can i load my data FAST i read some

$('#example').dataTable({
        "bPaginate": true,
        "bLengthChange": true,
        "bFilter": true,
        "bSort": true,
        "bInfo": true,
        "bAutoWidth": false,
        "bDestroy": false,
        "bJQueryUI": false,
        "sPaginationType": "full_numbers"
});

but i dont find the right solution to load fast a 10,000 data from data base

Upvotes: 1

Views: 4485

Answers (1)

tawman
tawman

Reputation: 2498

DataTables supports server-side paging that is quite easy to implement and well documented on its web site. I have implemented the DataTables server-side paging with PetaPoco and Entity Framework against SQL Server databases. The web site provides some PHP examples as well.

In terms of scalability, I demonstrated in a blog post of mine on Server-Side Paging with PetaPoco and DataTables, along with a GitHub reference implementation in .NET, how you can easily support millions of rows with less than a second page response times.

Upvotes: 1

Related Questions