Yet Another Large Table Issue

JanuszJasinski

Debugging ID: agecoz (http://debug.datatables.net/agecoz)

I have a table with 5k rows and 27 columns in total. The contains two rows as there's some to imitate the table here: http://www.datatables.net/release-datatables/examples/basic_init/complex_header.html

Running it in Chrome takes a few seconds, In Firefox I get the message whether I want to stop/start the script and IE just falls over. I've tried a number of options but nothing seems to work e.g.
[code]
"bServerSide": true,
"sAjaxSource": "data.asp",
"sServerMethod": "POST",
"bDeferRender": true
[/code]

I've tried using static data and data pulled from a database. I've run firebug on Firefox and it makes 5 calls in total to the data.asp page and some requests come back "401 unauthorized".

As the dataset is quite large, not sure what else I can do. I've checked other threads and tried to get from them what I can but going nowhere fast.

Any help would be greatly appreciated. Thanks!

allan

You've got server-side processing enabled, but you are returning all 5000 rows... That's not what server-side processing is for :-). It should return only the rows used for the current page - see http://datatables.net/usage/server-side

Allan

JanuszJasinski

Ok thanks - I have 27 columns in total. 3 of those will have pre-defined data in already. Can I simply "add" to the remaining 24 columns or will the script need to put to all 27?

Thanks!

JanuszJasinski

Ok I've given it a go - however when clicking "previous" or "next" nothing happens and firebug doesn't show anything error related either.... but my question above about the 24/27 columns still needs addressing pretty please anyone!

[FIXED]

allan

DataTables can't dynamically add new columns at the moment. So yes, all column data must be given.

Allan

JanuszJasinski

Excellent thanks - all sorted!