DataTables v1.9.4 Is there an upper limit on the number of rows it can cope with ?

DataTables v1.9.4 Is there an upper limit on the number of rows it can cope with ?

crawfcrawf Posts: 1Questions: 1Answers: 0

summary DataTables
description Paginate, search and sort HTML tables
version 1.9.4
file jquery.dataTables.js

My code:

$(document).ready(function(){
oTable = $('#userUsageTable').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"bSort": false
});

});

With less than ~6000 rows everything is ok. At around this limit I get :
java.lang.StackOverflowError
at com.sun.org.apache.xalan.internal.xsltc.util.IntegerArray.quicksort(IntegerArray.java:158)

a) Is this a known limit ?
b) Is there a way around it without upgrading to v1.10 ?
Apologies if this has been asked before.

regards,
Chris

Answers

  • aaronwaaronw Posts: 89Questions: 3Answers: 4

    java.lang sounds like a Java error. What is making the table on the server side? ARe you loading via AJAX or just creating a HTML table on the page itself? Datatables is Javascript so I'm not sure exactly where the error you post above is coming from.

  • allanallan Posts: 62,296Questions: 1Answers: 10,214 Site admin
    edited November 2015

    There is no limit in DataTables. Obviously at some point your browser will slow down and complain, but that shouldn't happen until around 50'000 rows - see FAQs.

    As aaronw says, the error you are getting is not caused by DataTables, but your Java code. Possibly out of memory.

    Allan

This discussion has been closed.