title: DataTable : How to make a page load faster?
body: <p>I have about <strong>20,000</strong> rows in my database, and I use <a href="http://www.datatables.net/" rel="nofollow">DataTable</a> to load all of those data.</p>
  
  <ul>
  <li>DataTable is loading all of my data at the beginning. </li>
  <li>DataTable works fine with a small amount of data like 100 or below, but in my case, my page took about <strong>3</strong> minutes to load a page. Very Bad ! </li>
  </ul>
  
  <p>What is the most efficient way to improve the loading speed using <strong>DataTable</strong> ?</p>
  
  <hr>
  
  <p><strong>Update:</strong></p>
  
  <p>Here is my table </p>
  
  <p><code>&lt;table id="inventory_exact"&gt; ...</code> </p>
  
  <p>Here is my setting to it </p>
  
  <pre><code>  // Setting to Inventory Table 
    $('#inventory_exact').dataTable({
  
      "lengthMenu": [ 10 ] ,
      "bLengthChange": false,
      "searchHighlight": true,
      "bInfo" : false
  
    });
  </code></pre>
  
  <hr>
  
  <p><strong>Update 2:</strong> - server side </p>
  
  <p>@niyou : I use PHP Laravel , so I <strong>query</strong> my data and <strong>display</strong> them by doing this </p>
  
  <pre><code>            @foreach ( Inventory::all() as $inventory)
               &lt;tr&gt;
                  &lt;td&gt;{{ $inventory-&gt;sku }} &lt;/td&gt;
                  &lt;td&gt;{{ $inventory-&gt;description }} &lt;/td&gt;
                  &lt;td&gt;${{ $inventory-&gt;price }} &lt;/td&gt;
                  &lt;td&gt;{{ $inventory-&gt;stock }} &lt;/td&gt;
               &lt;/tr&gt;
              @endforeach
  </code></pre>