how many rows can datatables hold for no performance issues?
how many rows can datatables hold for no performance issues?
bikai
Posts: 21Questions: 12Answers: 0
i have a large table, more than 5,000 rows.
i want to know what is datatables' performance specification?
can it hold 10,000 rows?
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Yes. There is no limit to the amount of data DataTables can hold, other than obviously the host computer's RAM.
Equally obviously, if each row has 500Kb worth of data, that is going to seriously impact performance relative to a table that has 1Kb worth of data for each row. Other considerations are how complex the HTML you are outputting for each cell, and if you are doing any DOM manipulation (showing Sparklines, adding classes, etc).
The simple fact is that tables are too flexible to say, yes, 10k is fine or not. It depends on the data and what you are doing with it.
See also the speed FAQ.
Allan