slow dashboard, how i can implante serverSide correctly

pathboot

hello,
i have a database with 1000 rows, wand when i go to dashboard its very slow to load because its load all row, i have only 10 rows to show in page, so i have try to implante server Side

this is my datatables.init.js

$(document).ready(function() {
$("#datatable").DataTable(), $("#datatable-buttons").DataTable({
lengthChange: !1,
processing: true,
serverSide: true,
buttons: ["copy", "excel", "pdf", "colvis"]
}).buttons().container().appendTo("#datatable-buttons_wrapper .col-md-6:eq(0)")
});

but that look do not work correctly, any idea what i need to add or change to get it working please
thank you

tangerine

$("#datatable").DataTable(), $("#datatable-buttons").DataTable({

Not sure you can do that. Never seen it before.

do not work correctly

That's not much help. What exactly is happening? Do you see errors? Have you done any debugging?

pathboot

no my dashboard and database working good
but its slow in browser because he load all rows in database
so i want limit it to get row load with pagination click

when i go to my dashboard that take more than 30 seconds to load 1000 rows
and i have only 10 to show in pagination

i havve ready here need to implante serveside
so i dont really know how i can set a limit

tangerine

https://datatables.net/reference/option/pageLength

pathboot

here when i go to dashboard, it take more than 30 seconds to load and i see he load all 1000 rows in my database

and here i have 10 entries per page

so i want make it to load only 10 row when im in page, and load 10 other entries when i go to next page

kthorngren

Server Side Processing is a client/server model. The server needs a script that supports. the Server Side Processing protocol. Take a look at these examples. These scripts use the ssp.class.php script. You can use the script or create your own that does something similar.

Kevin

pathboot

i have added

pageLength

but will getting load all work when i go to dashboard

pathboot

@kthorngren
i dont know how i can implante it, its not my own script, i want just to modifie it and make it fast, not slow when i go to dashboard

i see Client-side can support (50,000 rows), and in my case i have only 1000 rows and dashboard its slow, so if i continu to use client side how i can make it fast please

pathboot

this screenshot of my index.php maybe that help you to understand more

i have added
deferRender: true,
on datatables.init.js

but still slow and it load all row when i open index.php on my browser with only 1000 row on database

kthorngren

Since you are loading the table into the DOM the serverSide option won't be used. It is used with ajax loaded data. As a test comment out the Datatables init code and see how long the table takes to load. Let us know if its slow or fast. That will help determine where the slowness is coming from.

Kevin

pathboot

i have comment database init
and still slow
20 seconds to load ( i can see he load all 1000 row and after loading finish that show only 10 entries per page but in the first load i can see all 1000 row that loading )

pathboot

this is my /libs/datatables.net/js/jquery.dataTables.min.js

https://vf-manga.cc/player/assets/libs/datatables.net/js/jquery.dataTables.min.js

maybe thats help you to understand more
thanks

colin

This section of the FAQ should help, it discusses various techniques to improve performance,

Cheers,

Colin