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

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

El Forum
Unregistered

06-22-2014, 02:22 PM

[eluser]joergy[/eluser]
ever thought about
select count(id) from...
or similar, if You expect many records?

IMHO this
$this->db->query(preg_replace('/LIMIT.+$/i','', $sql))->num_rows();
isn't easy to read. Why not splitting...

Messages In This Thread

Is this bad sql to count total for pagination? (CI3-dev) - by El Forum - 06-20-2014, 09:58 AM

Is this bad sql to count total for pagination? (CI3-dev) - by El Forum - 06-20-2014, 04:49 PM

Is this bad sql to count total for pagination? (CI3-dev) - by El Forum - 06-22-2014, 02:22 PM

Is this bad sql to count total for pagination? (CI3-dev) - by El Forum - 06-23-2014, 02:42 AM

Is this bad sql to count total for pagination? (CI3-dev) - by El Forum - 06-23-2014, 10:31 PM