title: datatables with php and mysql large amount of data over 10000 records
body: <p>I'm using table-striped Datatables with my admin panel script and when try to display large amount of data from mySQL and PHP it take lots of time to load page. </p>
  
  <p>Below is code using with datatables:</p>
  
  <pre><code>&lt;script&gt;
  
      'use strict'; var Site = window.Site;
  
      $(document).ready(function($) { Site.run(); });
  
      (function() 
      {
          $(document).ready(function() 
          {
              var defaults = $.components.getDefaults("dataTable");
  
              var options = $.extend(true, {}, defaults, 
              {
                  "aoColumnDefs": 
                  [{ 'bSortable': false, 'aTargets': [-1] }],
  
                  "iDisplayLength": 10,
  
                  "aLengthMenu": 
                  [
                    [5, 10, 25, 50, -1],
                    [5, 10, 25, 50, "All"]
                  ],
  
                  "sDom": '&lt;"dt-panelmenu clearfix"Tfr&gt;t&lt;"dt-panelfooter clearfix"ip&gt;',
                  "oTableTools": { "sSwfPath": "../assets/vendor/datatables-tabletools/swf/copy_csv_xls.swf" }
              });
  
              $('#exampleTableTools').dataTable(options);
          });
      })();
  
  &lt;/script&gt;
  </code></pre>
  
  <p>How to load all records and in same load page faster.</p>