Slow data loading => Deferred rendering

Hi Tobias

Hope you are well.

I have the same problem like others, with a lot of data to load, it slows down performance.

But I think I found a solution in the script you are using: Deferred rendering seems to speed up loading the table, as it shows only the part of the table which will be displayed.

“Make sure you aren’t initialising the table in a display:none element
2. If you enable scrolling again, then make sure you also use Scroller and deferred rendering:
http://datatables.net/release-datatables/extras/Scroller/index.html

3. If you enable pagination, make sure you enable deferred rendering

See also http://datatables.net/faqs#speed”

“bDeferRender
Hide details
Deferred rendering can provide DataTables with a huge speed boost when you are using an Ajax or JS data source for the table. This option, when set to true, will cause DataTables to defer the creation of the table elements for each row until they are needed for a draw – saving a significant amount of time.”

This would be the ultimate solution
http://datatables.net/release-datatables/extras/Scroller/index.html
A table with 2500 rows x 5 columns = 12’500 cells loads in milliseconds!

Ans this is the initalisation code:
$(document).ready(function() {
var oTable = $(‘#example’).dataTable( {
“sScrollY”: “200px”,
“sAjaxSource”: “media/data/2500.txt”,
“sDom”: “frtiS”,
“bDeferRender”: true
} );
} );
This would be soooo great!!!! 🙂

Best regards,

Luigi

http://ww.wp.xz.cn/extend/plugins/tablepress/