Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 1 | espaco | 1 | <!DOCTYPE html> |
| 2 | <html> |
||
| 3 | <head> |
||
| 4 | <meta charset="utf-8"> |
||
| 5 | <link rel="shortcut icon" type="image/ico" href="http://www.datatables.net/favicon.ico"> |
||
| 6 | <meta name="viewport" content="initial-scale=1.0, maximum-scale=2.0"> |
||
| 7 | <link rel="stylesheet" type="text/css" href="../resources/syntax/shCore.css"> |
||
| 8 | <link rel="stylesheet" type="text/css" href="../resources/demo.css"> |
||
| 9 | <script type="text/javascript" language="javascript" src="../../media/js/jquery.js"></script> |
||
| 10 | <script type="text/javascript" language="javascript" src="../resources/syntax/shCore.js"></script> |
||
| 11 | <script type="text/javascript" language="javascript" src="../resources/demo.js"></script> |
||
| 12 | |||
| 13 | <title>DataTables examples - Server-side processing</title> |
||
| 14 | </head> |
||
| 15 | |||
| 16 | <body class="dt-example"> |
||
| 17 | <div class="container"> |
||
| 18 | <section> |
||
| 19 | <h1>DataTables example <span>Server-side processing</span></h1> |
||
| 20 | |||
| 21 | <div class="info"> |
||
| 22 | <p>There are many ways to get your data into DataTables, and if you are working with seriously large |
||
| 23 | databases, you might want to consider using the server-side options that DataTables provides. With |
||
| 24 | server-side processing enabled, all paging, searching, ordering etc actions that DataTables performs |
||
| 25 | are handed off to a server where an SQL engine (or similar) can perform these actions on the large data |
||
| 26 | set (after all, that's what the database engine is designed for!). As such, each draw of the table will |
||
| 27 | result in a new Ajax request being made to get the required data.</p> |
||
| 28 | |||
| 29 | <p>Server-side processing is enabled by setting the <a href= |
||
| 30 | "//datatables.net/reference/option/serverSide"><code class="option" title= |
||
| 31 | "DataTables initialisation option">serverSide<span>DT</span></code></a> option to <code>true</code> and |
||
| 32 | providing an Ajax data source through the <a href="//datatables.net/reference/option/ajax"><code class= |
||
| 33 | "option" title="DataTables initialisation option">ajax<span>DT</span></code></a> option.</p> |
||
| 34 | |||
| 35 | <p>The examples in this section shows server-side processing in use and how it can be customised to |
||
| 36 | suit your needs.</p> |
||
| 37 | </div> |
||
| 38 | </section> |
||
| 39 | </div> |
||
| 40 | |||
| 41 | <section> |
||
| 42 | <div class="footer"> |
||
| 43 | <div class="gradient"></div> |
||
| 44 | |||
| 45 | <div class="liner"> |
||
| 46 | <div class="toc"> |
||
| 47 | <div class="toc-group"> |
||
| 48 | <h3><a href="./index.html">Server-side</a></h3> |
||
| 49 | <ul class="toc"> |
||
| 50 | <li><a href="./simple.html">Server-side processing</a></li> |
||
| 51 | <li><a href="./custom_vars.html">Custom HTTP variables</a></li> |
||
| 52 | <li><a href="./post.html">POST data</a></li> |
||
| 53 | <li><a href="./ids.html">Automatic addition of row ID attributes</a></li> |
||
| 54 | <li><a href="./object_data.html">Object data source</a></li> |
||
| 55 | <li><a href="./row_details.html">Row details</a></li> |
||
| 56 | <li><a href="./select_rows.html">Row selection</a></li> |
||
| 57 | <li><a href="./jsonp.html">JSONP data source for remote domains</a></li> |
||
| 58 | <li><a href="./defer_loading.html">Deferred loading of data</a></li> |
||
| 59 | <li><a href="./pipeline.html">Pipelining data to reduce Ajax calls for paging</a></li> |
||
| 60 | </ul> |
||
| 61 | </div> |
||
| 62 | </div> |
||
| 63 | |||
| 64 | <div class="epilogue"> |
||
| 65 | <p>Please refer to the <a href="http://www.datatables.net">DataTables documentation</a> for full |
||
| 66 | information about its API properties and methods.<br> |
||
| 67 | Additionally, there are a wide range of <a href="http://www.datatables.net/extras">extras</a> and |
||
| 68 | <a href="http://www.datatables.net/plug-ins">plug-ins</a> which extend the capabilities of |
||
| 69 | DataTables.</p> |
||
| 70 | |||
| 71 | <p class="copyright">DataTables designed and created by <a href= |
||
| 72 | "http://www.sprymedia.co.uk">SpryMedia Ltd</a> © 2007-2014<br> |
||
| 73 | DataTables is licensed under the <a href="http://www.datatables.net/mit">MIT license</a>.</p> |
||
| 74 | </div> |
||
| 75 | </div> |
||
| 76 | </div> |
||
| 77 | </section> |
||
| 78 | </body> |
||
| 79 | </html> |