Performance comparison: CodeIgniter's result() vs. result_array()

Question

I use both result() and result_array().

Usually I like to get my result as array that's why I use result_array() mostly.

But I want to know which is the faster approach that I should follow. Which one of them is more efficient to use in regards to performance?

Here is the example I am talking about in CodeIgniter queries:

$query = $this->db->get(); $result = $query->result_array();

or is this should be the better approach?

$query = $this->db->get(); $result = $query->result();

Also, right now, I am using result_array() in my generic model.

Whisperity · Accepted Answer · 2013-05-12 11:23:03Z

Result has an optional $type parameter which decides what type of result is returned. By default ($type = "object"), it returns an object (result_object()). It can be set to "array", then it will return an array of result, that being equivalent of caling result_array(). The third version accepts a custom class to use as a result object.

The code from CodeIgniter:

/** * Query result. Acts as a wrapper function for the following functions. * * @param string $type 'object', 'array' or a custom class name * @return array */ public function result($type = 'object') { if ($type === 'array') { return $this->result_array(); } elseif ($type === 'object') { return $this->result_object(); } else { return $this->custom_result_object($type); } }

Arrays are technically faster, but they are not objects. It depends where do you want to use the result. Most of the time, arrays are sufficient.

dsdsdsdsd · Accepted Answer · 2016-05-16 16:08:47Z

for the sake of reference:

// $query->result_object() === $query->result() // returns: Array ( [0] => stdClass Object ( [col_A] => val_1A , [col_B] => val_1B , ... ) [0] => stdClass Object ( [col_A] => val_2A , [col_B] => val_2B , ... ) ... ) // $query->result_array() !== $query->result() // returns: Array ( [0] => Array ( [col_A] => val_1A , [col_B] => val_1B , ... ) [1] => Array ( [col_A] => val_2A , [col_B] => val_2B , ... ) ... )

codeigniter docs for result(), and result_array()

Saty · Accepted Answer · 2015-06-08 08:29:08Z

4

result_array() is faster, result() is easier

edited Jun 8, 2015 at 8:29

Saty

22.5k7 gold badges35 silver badges52 bronze badges

answered May 12, 2013 at 11:37

Emre Akay

1368 bronze badges

Comments

Harat · Accepted Answer · 2018-02-16 06:29:12Z

3

result() returns Object type data. . . . result_array() returns Associative Array type data.

answered Feb 16, 2018 at 6:29

Harat

1,3861 gold badge19 silver badges22 bronze badges

Comments

Daniel · Accepted Answer · 2013-05-12 11:23:02Z

1

Returning pure array is slightly faster than returning an array of objects.

answered May 12, 2013 at 11:23

Daniel

18.7k8 gold badges69 silver badges90 bronze badges

Comments

Nagendra Prasad Balaka · Accepted Answer · 2016-02-26 12:39:49Z

result() is recursive in that it returns an std class object where as result_array() just returns a pure array, so result_array() would be choice regarding performance. There is very little difference in speed though.

MD. Jubair Mizan · Accepted Answer · 2020-12-27 12:43:18Z

result_array() returns Associative Array type data. Returning pure array is slightly faster than returning an array of objects. result() is recursive in that it returns an std class object where as result_array() just returns a pure array, so result_array() would be choice regarding performance.

Wahyu Artadianto · Accepted Answer · 2017-01-04 05:56:16Z

in my experince the problem using result() and result_array() in my JSON if using result() there no problem its works but if using result_array() i got error "Trying to get property of non-object" so im not search into deep the problem so i just using result() if using JSON and using result_array() if not using JSON

Collectives™ on Stack Overflow

Performance comparison: CodeIgniter's result() vs. result_array()

8 Answers 8

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Related