How large the datatable can be?

johnsam

Hello,

I am using data-table for my application and big thanks .

I am displaying search results which contains records more than 1000 records,so when i display it,
i am viewing the progress bar in spite the records have been displayed in IE.any suggestions?? or is there a limit to display the data using data-tables?

awaiting your reply .

Thanks in advance,

John

28.vivek.s

you can limit the the records being displayed by using..

[code]iDisplaylength=100;[/code]

while initializing the datatable.

johnsam

when i display more than 1000 records i get message saying unresponsive script. any suggestion or solution for this ?

4giedrius

I think that problem is in your .php script. I tried DataTables with 10000 rows and 20 columns. Worked like a charm (~1s to generate table with PHP and 2-3s to get it sorted and displayed with DataTables).

johnsam

thanks for your input,i am using my JSON response to display,do we need to specify the max records in datatables?

UPEngineer

It sounds like you may have an error in your JSON return.

Check the JSON return using jsonlint.com and see if you have a parsing error.

sd_zuo

On Internet explorer, table performance is significantly lower than other browsers like Opera, Firefox, etc.
A table with 2000 rows fed by JSON records, paged, is OK. It also takes a lot of memory. :(

johnsam

@UPEngineer: thanks :)

@sd_zuo:memory is a BIG concern :( :(

sd_zuo

Yep, it really really sucks.
On my IE8 a 2000-rows datatable (10 rows displayed per page) with some CSS styling and fnRender functions consumes about 100MB memory, and the sorting will trigger IE's "slow script" alert.
On my Opera 11, the same amount of data and configuration, 1 second = done. However, there's still a pretty amount of memory consumption.

johnsam

:( ...

@allan:any suggestions or thoughts on this issue?.

any help/suggestions appreciated.

allan

Is fnRender itself consuming the memory? If you remove it does the usage drop by 100MB? If so, then it sounds like there might be a closure going on. Are you unbinding any events which are added to elements etc?

Allan