High Page Load about ignited-datatables HOT 2 CLOSED

I solved my problem replacing:

Line 369:
$iTotal = $rResult->num_rows();
$iFilteredTotal = $this->get_total_results(TRUE);

Line 447:
return $this->ci->db->count_all_results($this->table, NULL, NULL, FALSE);

from ignited-datatables.

$rResult->num_rows(); is not total rows. it is filtered rows (10,20 rows depends on page counts. )
You will need at least 3 sql query.
1 for pagination. This is how many rows u will show.
1 for filtering count -> this is how many records filtered by searching
1 for all records count..

from ignited-datatables.