mysql_fetch_row() in CodeIgniter

[eluser]punchi[/eluser]
My solution:

Change

Code:

while($row = $this->db->call_function('fetch_row', $query)) {
    $return[] = $row;
}

for

Code:

while($row = mysql_fetch_row($query)) {
    $return[] = $row;
}

The page speed up a 350% (from 0.0035 to 0.0010). The differences between foreach ($query2 as $row) and foreach ($query->result() as $row) are insignificant.

And now, between the "almost-always-used"

Code:

$sql = 'SELECT ID_PLAN, PL_NAME plan';
$query = $this->db->query($sql);

and

Code:

$sql = 'SELECT ID_PLAN, PL_NAME plan';
$query = mysql_query($sql);

        while($row = mysql_fetch_row($query)) {
                $return[] = $row;
        }

return $return;

The last one, its 170% more efficient. Another reason Jedd ;-)

What I don't know, if working with CodeIgnite and PHP native functions, have some incompatibilities or is inappropriate...

Thanks! =)