问显示mysql记录的最佳分页方式是什么

EN

public function page($category_id)
{

$result = $this->model_file->model_function($category_id);

$start_index = 0;

$total_rows = count($result);

$items_per_page = 10;

$filtered = array_splice($result,$start_index,$items_per_page);

$model['data'] = $filtered;

$model['page_link'] = create_page_links (base_url()."/controller_file_name/page", $items_per_page, $total_rows);

$this->load->view('view_file_name_path',$model);

}

function create_page_links($base_url, $per_page, $total_rows) {

$CI = & get_instance();
$CI->load->library('pagination');

$config['base_url'] = $base_url;
$config['total_rows'] = $total_rows;
$config['per_page'] = $per_page; 

$CI->pagination->initialize($config); 

return $CI->pagination->create_links();

}