count_all_results() - is it optimized?

I think that the ideal is use the cli for mysql in CI, I don't sure what is more fast method, in my case ever try to use the CI cli mode, I mean to this method in modal side:

$this->db->count_all_results();

Anyway you can use maybe this in your views printing the load time showing the load time:

{elapsed_time}

And test in different pages each one with one method :-), or think thats better use the class Benchmarking:

https://www.codeigniter.com/userguide3/l...hmark.html