Datatables loading speed

jrowan20

Hey All, I have a table which will be holding over 30,000 records, mostly just customer data nothing too substantial. I have loaded the data into my table, but it takes about a minute to load. Im not using server side rendering, but its something I will probably have to pursue. My question is; is this typical behaviour for a datatable of only 30,000 rows of data? I thoought the client side rendering would have handled this quite easily.

I cant find any documentation and i understand its on a case by case basis, but is there a max amount of rows before server side rendering is encouraged?

Also, I have noticed if i fetch my data using an ajax call instead of a forEach loop the response is noticeably faster, is this typical also?

forgive me, I am new to datatables

kthorngren

If you use the ajax option to fetch the data you can try using deferRender to see if it helps. Basically you need to find out if the delay is with fetching the data or rendering the page. See this FAQ.

Kevin

jrowan20

Ahh cheers Kevin thanks i'll have a nose now