DataTable became very slow!

I'm using dataTable in my project and it's working fine. But when the amount of data is thousand plus or more, it's becoming very slow to load the page. How can i fix this?

May be pagination can be a solution. But i need to use dataTable's search filter. So how can i fix this problem using dataTable?

Yorki

7 years ago

Level 11

You shouldn't load all your data at once and data tables does support server side processing.

"There are many ways to get your data into DataTables, and if you are working with seriously large databases, you might want to consider using the server-side options that DataTables provides. With server-side processing enabled, all actions that DataTables performs (such as paging, searching and ordering) are handed off to a server where an SQL engine (or similar) can perform these actions on the large data set (after all, that's what the database engine is designed for!). As such, each draw of the table will result in a new Ajax request to get the required data."

https://datatables.net/examples/server_side/

1 like

jlrdw

7 years ago

Level 75

Learn proper pagination with data tables. Their site will have numerous examples of searching and pagination.

And then you will adapt to a laravel controller and model for the server side back end.

Please or to participate in this conversation.