Is this bad sql to count total for pagination? (CI3-dev)

[eluser]treenef[/eluser]
You should always optimize your queries if you CAN by doing a limit. An example, would be selecting a password for a userid. Do a limit(1) as there should only be one row returned.

Additionally, avoid using $this->db->select('*') where you can.

Unfortunately, if you don't know how many rows are to be returned you can't do much about it, as if you try and limit your query you might miss important data.

Hope that helped.