If i have one million rows in mysql table, how use paginator?
Interesting!! I think you need to do the following ;
->nomalize the tables.
->have search functionality in your application.
->Create menu for your data View. The menu can have submenu etc.
Just working on the structure first before getting down to pagination.
To use paginator with a resultset that large, you'll want to look here:
Look at the example using "QueryBuilder"
//Passing a querybuilder as data
$builder = $this->modelsManager->createBuilder()
$paginator = new PaginatorQueryBuilder(array(
"builder" => $builder,
"limit" => 20,
"page" => 1
That will query only the results you're looking for on any given page instead of the entire resultlet.