Codeigniter:$query->free_result() when using active record?

Question

after i have finished with my result set from a active record query in a CodeIgniter model, should I use $query->free_result() or does ActiveRecord automatically do that?

Stack Programmer · Accepted Answer · 2018-11-10 17:31:50Z

20

PHP will clean up everything after your script is done. However, if you have lots of queries in, say, a loop, the results will not be cleaned up after each iteration.

So, if you run lots of queries in a loop, you probably will want to free_result() to clear up memory. Otherwise, it's not necessary. See here for details:

https://www.codeigniter.com/user_guide/database/results.html

edited Nov 10, 2018 at 17:31

Stack Programmer

6776 silver badges18 bronze badges

answered Apr 21, 2009 at 23:58

v3.

2,02316 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user9645 Over a year ago

The link no longer works. The relevant version 3 page is here

Collectives™ on Stack Overflow

Codeigniter:$query->free_result() when using active record?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related