title: DataTable server request on pagination
body: <p>I am using data table for pagination,As it is client side so getting whole data(more than 50000) makes my page too busy and crash it.
  Here is my code.what should I do?</p>
  
  <pre><code>$q="select * from table";
  $rs = $oAppl-&gt;query($q);
  &lt;table class="display" id="example"&gt;
              &lt;thead&gt;
                  &lt;tr&gt;
                     &lt;th class="th_title"&gt;ID&lt;/th&gt;
                     &lt;th class="th_title"&gt; Name&lt;/th&gt;
                    &lt;/tr&gt;
              &lt;/thead&gt;
              &lt;tbody&gt;
              &lt;?php
               while ( $rw = $oAppl-&gt;row($rs) ) {
               ?&gt;
                  &lt;tr class="item"&gt;
                      &lt;td &gt;&lt;?php echo $rw["id"]; ?&gt;&lt;/td&gt;
                     &lt;td class="subject"&gt;&lt;?php echo $rw["name"]; ?&gt;&lt;/td&gt;
     &lt;/tr&gt;
                 &lt;?php
                 }
                 ?&gt;
              &lt;/tbody&gt;
          &lt;/table&gt;
   $(document).ready(function() {
  $('#example').dataTable();
   }
  </code></pre>