Performance with many data

veloopity

When I load 1000 or 5000 rows from a database table (on an older server which isn't extremely fast), after the rows are read I first see a table without pagination and datatables formatting - this is visible for a second or so, then after this the data are displayed the way they should be displayed.
Datatables needs a certain time to create the formatting (pagination, alternating row colors, search- and menu options, etc) - my impression is that the time this takes depends on the number of data rows, even though with pagination, only the first 10 rows get displayed, regardless of the total number. If this is true, I wonder if there is a way to make it display the paginated first 10 rows immediately while still formatting the other rows in the background. This would make for a smoother user experience.

-Michael

kthorngren

first see a table without pagination and datatables formatting - this is visible for a second or so

Sounds like this delay is before Datatables starts initialization while the DOM table is built. You could hide the table then show it using initComplete

If this is true, I wonder if there is a way to make it display the paginated first 10 rows immediately while still formatting the other rows in the background.

You can use deferRender. This will render the rows when they are displayed. No background rendering.

Kevin

kthorngren

This example shows a quick way for you to see how long it takes Datatalbes to initialize:
http://live.datatables.net/fomaqofu/1/edit

This may help you decide where the delay is.

Kevin

kthorngren

Sorry, deferRender works with ajax or Javascript loaded data. see this FAQ for options to increase the speed.

Kevin