Datatables rendering crashes in chrome

ssreehari16

Hi, I am fetching an array of 100k elements through ajax call and creating a table of 37 columns. after ajax call chrome takes all of the available memory(around 2.6 GB) and crashes with a message out of memory. It works fine with 50000.

Please help me

allan

For that number of rows use server-side processing. Or if that isn't an option, make sure you have deferRender enabled. If that doesn't help enough, then server-side processing is the way forward.

Allan

ssreehari16

Hi Allan,
Thanks for the reply. I have a date range picker in the webpage which i use to filter the data in the table. I also have an excel button to download the table as excel . Will all of these possible if I opt for server side processing?

kthorngren

I have a date range picker in the webpage which i use to filter the data in the table

You will need to send these values to the server so. the server script can use the range in the DB query. See this example.

I also have an excel button to download the table as excel

No. See this FAQ.

Kevin