Very Slow charging with DataTable

mf_a2if

Hi all,

I use DataTable and some plug-ins for my job (TableTools, ColumnFilter, RowGrouping and HighCharts)
I have more 200 000 datas in base, and in the same page, i have 6 tables, with each more 200 000 datas so.

I can't see my page cause [quote]PHP Allowed Memory Size Exchausted Fatal Error[/quote]
So I have used [quote]ini_set('memory_limit', '-1');[/quote]

But now, i don't have the same result : no pagging, no grouping, etc. Or with just 500 datas in base, it's ok.
Furthermore loading page is VERY VERY VERY long.

How can I do ?

allan

Sending no memory limit is a sure fire way of killing your server - I'd recommend against that!

For just DataTables, I'd suggest you use server-side processing, which should easily cope with 200'000 rows. I'm not sure what you would do about HighCharts though, if it needs the full data set. I'd suggest perhaps using PHP debugging tools to see what is taking the memory. Worth noting that PHP is very inefficient when using large numbers of arrays like that, but that's well outside the scope of DataTables!

Allan

mf_a2if

Thank you for your response.

I will see server-side processing, I think it's the best solution.

I come back if I have question about it ^^.

Thanks again

Magali