Display over 10000 rows
Display over 10000 rows
Seppelchen
Posts: 69Questions: 25Answers: 1
Hello, we are create a normal php call like:
$testquery = mysqli_query($db_link, "SELECT * FROM datenpflege_npr");
And than we will display all rows on datatables.
Now we get a big issue, if we insert a lot of rows like 15000 than it will take a long time and it will build also a loading error.
Did you had any idea how we could made this call smart , that it will work fast?
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Hi,
Have a look at the Q. DataTables is running slow. How can I speed it up? FAQ.
Allan
Hello , did we need only set up true to serverside?
Because all our rows are stored @ one database table.
Could you maybe submit a excat example? We also could pay for it.
Because now we dont had set this variable and it will load and load and broke up.
There are lots of server-sid eprocessing examples available on this site.
See also the manual for the server-side processing interface.
Allan
Hello, we had get a solution but get issues with special characters like ä, ü, ß and so on. We had submit a new post: http://datatables.net/forums/discussion/28702/special-charackter-ss-ae-oe-ue
hope you can submit a solution to fix it.