All table data to array.

svendber

Hi,

I've got a table with 150.000+ rows.
It's possible to get the data like this, but only recording to how many entries showing.

var snipArray = tableSnip.rows().data().toArray(); 

However, I need it all, and if I set paging: false for the table, which will load the entire data into the table, it gives me the memory error.

That said, I do not need to show the table, but only get the data into an array. Is it possible to reduce the load or maybe an API?

Cheers.

kthorngren

If you want to fetch all the data outside of Datatables you can use a jQuery ajax request.

Kevin

svendber

ty for answer @kthorngren but isn't it possible with Datatables?

kthorngren

but isn't it possible with Datatables?

However, I need it all, and if I set paging: false for the table, which will load the entire data into the table, it gives me the memory error.

Sounds like if you try to fetch all the data with Datatables you get an error.

I do not need to show the table, but only get the data into an array.

If you don't want Datatables to display all the data but want to place it in an array then the wayt o do this is with using jQuery ajax to fetch the data.

Is it possible to reduce the load or maybe an API?

See this FAQ:
https://datatables.net/faqs/index#speed

Kevin