Pagination: Can this be improved?

[eluser]mcr_rm[/eluser]
I do it like this in my models...doesn't save you from overhead of calls to the db but it works for me. I then pass [results] to my view and [total] to the pagination class through my controller. Rather than making two calls from the controller I make one, however say you didn't want the total that is extra overhead that could be avoided doing as above functions.

Code:

public function _getAll($limit=10, $offset=0)
    {
        
        $this->db->flush_cache();
        $this->db->start_cache();
        $this->db->from($this->db_table);

        
        $this->db->stop_cache();
        
        $return=array();
        $return['total']=$this->db->count_all_results();
        
        $this->db->limit($limit, $offset);
        $this->db->order_by('id', 'DESC');
        $query = $this->db->get();
        $return['results']= $query->result();
        
        
        return $return;

    }

PS clearly you might want to pass in what you want to order results by also!