Display problem when the database becomes large

Question

I have a display problem when the database becomes large ,it hangs and it gives no answer with an average database no prblem how i can apply server-side processing in my case thanks

Sachin Singh · Answer

follow this, this will give you correct insights, please use column names in Ajax call inside your datatable then on server side send data based ob length of table, means if you have 10k rows then first 100 rows will be fetched from server and then on scroll or page number click rest 100 and so on. https://www.codeproject.com/Tips/1237576/Datatables-net-Deferred-Loading-of-Data-using-ASP

Mouhssine tahri · Answer

hi, in my application i am using webapi to retrieve the data I use the function get_allStatEntite below the function get_allStatEntite call a function fillStatPosteDataTable to fill the table if possible i want to use the same approach to solve the problem function get_allStatEntite(StatCode) { var apiurl = "http://localhost:14405/api/EntiteApi?StatEntite=" + StatCode; $.ajax({ url: apiurl, type: 'GET', dataType: 'json', success: function (d) { AllStatPoste = d; fillStatPosteDataTable(AllStatPoste); }, error: function () { alert("Error please try again"); } }); } function fillStatPosteDataTable(AllStatPostes) { var table = $('#StatPosteTable').DataTable(); var rows = table .rows() .remove() .draw(); AllStatPostes.forEach(AllStatPoste => { var rowId = "crow_" + AllStatPoste.codePoste; var row = table.row.add([ " " + today + " ", " " + AllStatPoste.codePoste + " ", " " + AllStatPoste.intitule + ': ' + AllStatPoste.employe + " ", " " + AllStatPoste.numeroAppele + " ", " " + durree + " ", " " + AllStatPoste.sonnerie + " ", " " + AllStatPoste.cout + " ", " " + AllStatPoste.sda + " " //action ]); //row.node().id = rowId; table.draw(); }); }

Mouhssine tahri · Answer

THANKS SAchin for replay I am a beginner can you explain how use my function get_allStatEntite and fillStatPosteDataTable in that case $(document).ready(function() { $('#example').DataTable( { serverSide: true, ordering: false, searching: false, ajax: function ( data, callback, settings ) { var out = []; for ( var i=data.start, ien=data.start+data.length ; i out.push( [ i+'-1', i+'-2', i+'-3', i+'-4', i+'-5' ] ); } setTimeout( function () { callback( { draw: data.draw, data: out, recordsTotal: 5000000, recordsFiltered: 5000000 } ); }, 50 ); }, scrollY: 200, scroller: { loadingIndicator: true }, } ); } );

Sachin Singh · Answer

Then use Lazy loading with server side processing here is the datatable documentation https://datatables.net/extensions/scroller/examples/initialisation/server-side_processing.html

Mouhssine tahri · Answer