Many rows on Datatable more than 50 000

DevCy

Hi, i've a question, i work with a Datatable with more than 50 000 rows. I try to use Datatable with that. I've all my datas on a json file. i will have all my datas for search filter with Datatable. I added serverSide and deferRender but it don't works. I've too many datas. Are you an idea ??
Thank you for help.

$('#many-table').DataTable({
                    processing: true,
                    pageLength: 100,
                    serverSide: true,
                    deferRender:false,
                    ajax: '/url/many/show',
                });

allan

Does your Ajax controller support server-side processing?

Allan

DevCy

My controller return an jsonResponse with all datas. Can i use server-side processing inside controller with Laravel ?? I don't know for moment i try many things and i'm blocked with that.

kthorngren

Datatables doesn't supply a Laravel library for server side processing. There are third party libraries. This tutorial shows how to use Yajra Datatables. Maybe this will work for you. Or you can create your own code that supports the server side processing protocol.

Kevin

DevCy

Hi, thank you for response i will try this.
Have a good day

DevCy

Finally i worked with yarja datatables and it's works fine. Thank you for your help