slow dashboard, how i can implante serverSide correctly

slow dashboard, how i can implante serverSide correctly

pathbootpathboot Posts: 8Questions: 1Answers: 0

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

Answers

  • tangerinetangerine Posts: 3,245Questions: 30Answers: 385

    $("#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?

  • pathbootpathboot Posts: 8Questions: 1Answers: 0
    edited March 2022

    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

  • pathbootpathboot Posts: 8Questions: 1Answers: 0


    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

  • kthorngrenkthorngren Posts: 17,759Questions: 25Answers: 4,216

    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

  • pathbootpathboot Posts: 8Questions: 1Answers: 0

    i have added

    pageLength

    but will getting load all work when i go to dashboard

  • pathbootpathboot Posts: 8Questions: 1Answers: 0

    @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

  • pathbootpathboot Posts: 8Questions: 1Answers: 0
    edited March 2022

    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

  • kthorngrenkthorngren Posts: 17,759Questions: 25Answers: 4,216

    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

  • pathbootpathboot Posts: 8Questions: 1Answers: 0
    edited March 2022


    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 )

  • pathbootpathboot Posts: 8Questions: 1Answers: 0

    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

  • colincolin Posts: 14,618Questions: 1Answers: 2,497

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

    Cheers,

    Colin

Sign In or Register to comment.