09-04-2009, 02:00 PM
[eluser]jedd[/eluser]
$this->db->limit(1);
I think I read once that random order by is expensive compared to calculating the max row number, then using a php random function to pick a row #, and doing a lookup of that row.
$this->db->limit(1);
I think I read once that random order by is expensive compared to calculating the max row number, then using a php random function to pick a row #, and doing a lookup of that row.