title: datatable does not support if more than 60000 records are being fetched
body: <p>we want to store large number of data (more than 60K rows ) in datatable but the datatable fails to executes and output is not coming well. The datatable will not fails till 20000 records. Here is fhe following source code</p>
  
  <pre><code> &lt;div class="row"&gt;
                          &lt;table id="customer_table"  class="display" cellspacing="0" width="100%"&gt;
                           &lt;thead&gt;    
                      &lt;tr&gt;
                          &lt;th&gt;#&lt;/th&gt;
                          &lt;th&gt;Customer Name&lt;/th&gt;
                          &lt;th&gt;Email&lt;/th&gt;
                          &lt;th&gt;Group&lt;/th&gt;
                          &lt;th&gt;Action&lt;/th&gt;
                      &lt;/tr&gt;
                  &lt;/thead&gt;
                  &lt;tbody&gt;
  
  
      &lt;?php   for($p=1;$p&lt;=200;$p++)
  
      {
  
      $ch = curl_init("https://$shop_name/admin/customers.json?limit=250&amp;page=".$p."");
                      curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "GET"); 
                      curl_setopt($ch,CURLOPT_RETURNTRANSFER,TRUE);
                      curl_setopt($ch, CURLOPT_POSTFIELDS, $params); 
                      curl_setopt($ch, CURLOPT_HTTPHEADER, array("Content-Type: application/json",
                                          "X-Shopify-Access-Token: $store_token"));
                       $result = curl_exec($ch);
                      $decoded_customer = json_decode($result, true); 
                      //var_dump($decoded_customer); 
                      ?&gt;
  
      &lt;?php for($i=0;$i&lt;count($decoded_customer['customers']);$i++)
  
      {
      ?&gt;
              &lt;tr&gt;
              &lt;input type="hidden" value="&lt;?php echo $decoded_customer['customers'][$i]['id']; ?&gt;" &gt;
              &lt;td&gt;#&lt;/td&gt;
              &lt;td&gt;&lt;?php echo $decoded_customer['customers'][$i]['first_name']." ".$decoded_customer['customers'][$i]['last_name'];?&gt;&lt;/td&gt;
              &lt;td&gt;&lt;?php echo $decoded_customer['customers'][$i]['email']; ?&gt;&lt;/td&gt;
              &lt;td&gt;
  
        &lt;select class="form-control" &gt;
             &lt;option value="" &gt;
                 No Selected
              &lt;/option&gt;
                  &lt;?php 
                  session_start();
  
                  $shop_name = $_SESSION['shop'];
                  include("dbconnect.php");
  
                  $sql_select_tbl_shop = "SELECT * FROM `store_info_tbl` WHERE `store_name` = '$shop_name'";
                  $select_tbl_shop = mysql_query($sql_select_tbl_shop);
  
                  if(mysql_num_rows($select_tbl_shop)&gt;0){
  
                  $row_select_val=mysql_fetch_array($select_tbl_shop );
                  $shop_id=$row_select_val['id']; 
  
                  //select selected group name
                  $customer_id=$decoded_customer['customers'][$i]['id'];
  
  
                  $sqlselectgroup_customer="SELECT * FROM `tbl_group` WHERE `store_name`='$shop_id'";
                  $resselectgroup_customer=mysql_query($sqlselectgroup_customer);
                  if(mysql_num_rows($resselectgroup_customer))
                  {
                    while($rowselectgroup_customer=mysql_fetch_assoc($resselectgroup_customer))
                    { 
                  $sqlselectcustomergroup="SELECT * FROM `tbl_customer_detail` WHERE `customer_shop_id`='$customer_id'";
                  $resselectcustomergroup=mysql_query($sqlselectcustomergroup);
  
                  if(mysql_num_rows($resselectcustomergroup)&gt;0){
                  //$rowselectcustomer=mysql_num_rows($resselectcustomergroup);
  
                   //$rowid=mysql_fetch_array('group_name');
                   $rowid=mysql_fetch_array($resselectcustomergroup);
                   $customer_group=$rowid['group_name'];
  
                  ?&gt;
  
              &lt;option value="&lt;?php echo $rowselectgroup_customer['id']; ?&gt;" &lt;?php if($customer_group==$rowselectgroup_customer['id']) { ?&gt;selected &lt;?php } ?&gt; &gt;
              &lt;?php echo $rowselectgroup_customer['group_name']; ?&gt;
              &lt;/option&gt;
                &lt;?php } else{ ?&gt;
  
             &lt;option value="&lt;?php echo $rowselectgroup_customer['id']; ?&gt;" &gt;
              &lt;?php echo $rowselectgroup_customer['group_name']; ?&gt;
              &lt;/option&gt;
  
                  &lt;?php  } } } } ?&gt;
  
              &lt;/select&gt;
              &lt;/td&gt;
              &lt;td&gt;&lt;button type="button" class="btn btn-primary save"&gt;Save&lt;/button&gt;&lt;/td&gt;
              &lt;/tr&gt;
              &lt;?php } } ?&gt;
  
  
  
      &lt;/tbody&gt;
  
      &lt;/table&gt;
  
      &lt;script type="text/javascript" &gt; 
                 $(document).ready(function(){
                   $('#customer_table').DataTable();
  
                 }); 
                 $(document).on('click','.save',function(){
                     var shopify_customer_id=$(this).parent().parent().find('input').val();
                     var customer_name=$(this).parent().parent().find('td').eq(1).html();
                     var customer_email=$(this).parent().parent().find('td').eq(2).html();
                     var group_name=$(this).parent().parent().find('td').find('select').val();
                    //alert(shopify_customer_id+customer_name+customer_email+group_name);
  
  
                    $.ajax({
                          type: "post",
                          url: "ajaxcustomerdata.php",
                          data: {
                              shopify_customer_id:shopify_customer_id,
                              customer_name:customer_name,
                              customer_email:customer_email,
                              group_name:group_name
                          },
                          success: function (data){
                             alert(data);
  
                          },
                          error: function (xhr, ajaxOptions, thrownError){
                          }
                      });
  
  
  
                     });
  
              &lt;/script&gt;
              &lt;script&gt;
  
              &lt;/script&gt;
  
  
  
      &lt;/div&gt;
  </code></pre>
  
  <p>If any one has any kind of suggestion please help me out to resolve this problem</p>