I am working on improve performance for a page that shows students information list ( around 10000 students). the page using datatable to show the list, but its very slow. My team leader suggested to replace the datatable with another thing to show the list because datatable is very slow, but I read an article says:
"if you are working with seriously large databases, you might want to consider using the server-side options that DataTables provides".
what is the correct way to show list of huge data ?
You will need to do server paging, it means that on each page call will call the server and get current page data.
When using server-side paging the client and server will server a small amount of date (current page data only).
Also, Its Lazy Loading.
Lazy mode is handy to deal with large datasets, instead of loading the entire data, small chunks of data is loaded by invoking onLazyLoad callback everytime paging, sorting and filtering happens.