huge data in jquery datatable cannot scroll to bottom?

huge data in jquery datatable cannot scroll to bottom?

matt.crawfoordmatt.crawfoord Posts: 31Questions: 13Answers: 0
edited July 2016 in Free community support

I am using jQuery Data Table plugin where I select a lot of data from server side. I try to using scroll to display these huge data (more than 500,000) ,
but when I scroll to the end of the bottom , It's will back to top. And I found it's cannot scroll more than 10000 records. It's will back to top soon.

my code as follow,

$(document).ready(function() {   
  $.fn.dataTable.ext.errMode = 'none';
  var table = $('#example').DataTable( {
    "processing": true,
    "serverSide": true,
    "jQueryUI": true,
    "ordering": true,
     "searching": true,
     "order": [[1, 'desc']],//default
      "lengthMenu": [
        [50, 100, 1000],
        [50, 100, 1000]
      ],

    "ajax": {
       url: "process.php",
       type: 'POST',
       data: {
       start: "<?php echo $start; ?>",
       end: "<?php echo $end; ?>"
          }

       },

    "columns": [
        {
            "className":'details-control',
            "orderable":false,
            "data":null,
            "defaultContent": ''
        },
        { "data": "time"},
    { "data": "message","orderable": false}

    ],
    "dom": 'frtiS',
    "scrollY": 600,
    "scroller": {

         "loadingIndicator": true
    },
    "deferRender":    true

} );

Please help me do that, or suggest better solution.

Answers

  • allanallan Posts: 61,451Questions: 1Answers: 10,055 Site admin

    Thanks for your question - however, per the forum rules can you link to a test case showing the issue please. This will allow the issue to be debugged.

    Information on how to create a test page, if you can't provide a link to your own page can be found here.

    Thanks,
    Allan

  • matt.crawfoordmatt.crawfoord Posts: 31Questions: 13Answers: 0
    edited July 2016

    allan ,
    because these are private data sets , can i send you the link via email ?

  • allanallan Posts: 61,451Questions: 1Answers: 10,055 Site admin

    Sure - drop me a PM by clicking my name above and then the "Send message" button.

    Allan

This discussion has been closed.