How can i fast load large amount of data using datatables?

Question

I'm using Datatables to load data from database. My table has more than 3000 entries which i show on my frontend using datatable. But it take too much time to load data. image showing slow loading of data in datatable

Datatable intialize here:

 $(document).ready(function () {
            $('.schools').DataTable({
                ordering: false,
                responsive: true,
                columnDefs: [
                    {responsivePriority: 1, targets: 0},
                    {responsivePriority: 2, targets: -3},
                ]
            });
        })

Laravel code to bring data from database:

public function show()
    {
        $schools = DB::table('schools')->get();
        return view('admin.school.view', compact('schools'));
    }

Pagination is your friend. You rarely need to show 3000 entries on a single page. — brombeer, Nov 04 '20 at 08:46
you can use server side datatable. you can check this [package](https://github.com/yajra/laravel-datatables) too. — zahid hasan emon, Nov 04 '20 at 08:47

score 0 · Answer 1 · answered Nov 04 '20 at 08:57

0

Nobody can't read 3000 entries at the same time. Try fetching entries per 30 pieces and insert next and back buttons in order not to load the system with unnecessary data.

answered Nov 04 '20 at 08:57

Nagmat

373
4
14

any example how to do this ? – ZAIN UL ABIDEEN 152 Nov 04 '20 at 09:07
Try https://stackoverflow.com/questions/4329396/mysql-select-10-random-rows-from-600k-rows-fast link, there are many similar examples. – Nagmat Nov 05 '20 at 05:44

How can i fast load large amount of data using datatables?

1 Answers1