Maximum Number of Records

redojz

Hi All,
How does dataTables handle a large number of records? I have a table that has over 100,000 records in it, but I have the user enter a search criteria which the maximum returned can be about 40,000 for one of the entries. This is the search criteria with a large return. All the other search criteria range from 1 to 4,000 records. What is the best to display and search this type of table (large number of records)? Thank you and I appreciate your input.

allan

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

Allan

redojz

Because I am not using Ajax, my only option is to disable bSortClasses. So, the table will handle a maximum of 5000 records correct? And if I wanted to increase the maximum, I would have to implement Ajax? Thank you for your patience. :)

allan

5000 is not a hard limit - it will handle as many as the RAM on the computer allows. Its just that I would recommend using Ajax at that point.

Allan

redojz

Ok. Thank you Allan.