Welcome Guest, Not a member yet? Register   Sign In
SQL Query
#2

[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.


Messages In This Thread
SQL Query - by El Forum - 09-04-2009, 01:58 PM
SQL Query - by El Forum - 09-04-2009, 02:00 PM
SQL Query - by El Forum - 09-04-2009, 02:02 PM



Theme © iAndrew 2016 - Forum software by © MyBB