Datatables loading speed
Datatables loading speed
jrowan20
Posts: 13Questions: 7Answers: 0
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
Answers
If you use the
ajaxoption to fetch the data you can try usingdeferRenderto 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
Ahh cheers Kevin thanks i'll have a nose now