[eluser]sikko[/eluser]
Hi,
I'm wondering what way is the most "performance friendly" to count rows matching a where clause.
I just read the user guide and found this:
$this->db->like('title', 'match');
$this->db->from('my_table');
echo $this->db->count_all_results();
I'm wondering if the query is fully executed behind, and counted after, or if a "SELECT COUNT" is executed by codeigniter.
Thank you by advance.
sikko