when I use server-side processing, need I pass back all rows to dataTable?
when I use server-side processing, need I pass back all rows to dataTable?
yogurt1206
Posts: 1Questions: 0Answers: 0
Hi, I'm a starter of dataTables. I have a question when create the php file for server-side processing.
Look at the codes below. If I set iDisplay=5 and the php file will return 10 entries. The php file will be called once or twice?
Thanks for your answers!
[code]
/*
* Paging
*/
$sLimit = "";
if ( isset( $_GET['iDisplayStart'] ) && $_GET['iDisplayLength'] != '-1' )
{
$sLimit = "LIMIT ".intval( $_GET['iDisplayLength'] )." OFFSET ".
intval( $_GET['iDisplayStart'] );
}
[/code]
Look at the codes below. If I set iDisplay=5 and the php file will return 10 entries. The php file will be called once or twice?
Thanks for your answers!
[code]
/*
* Paging
*/
$sLimit = "";
if ( isset( $_GET['iDisplayStart'] ) && $_GET['iDisplayLength'] != '-1' )
{
$sLimit = "LIMIT ".intval( $_GET['iDisplayLength'] )." OFFSET ".
intval( $_GET['iDisplayStart'] );
}
[/code]
This discussion has been closed.
Replies
No. The whole point of server-side processing is that you only pass back the rows that DataTables asks for. This allows it to very easily cope with showing just 10 rows from 20 million for example...
See the documentation here: http://next.datatables.net/manual/data#Processing-modes
Allan