How do I show loading in Datatable?
There are some tricks to show loading indicator when retrieving data via Ajax request using jQuery DataTables. Recommended way to reload data in the table powered by jQuery DataTables is to use ajax. reload() API method. jQuery DataTables allows to display a processing indicator using processing option.
How do I reduce datatable loading time?
Consider condensing your display, and putting more records on a page. Better than code for this is going to be actually giving a link to the page if possible; its entirely plausible that the datatable isnt your choke point.