ActiveRecord and Changing database rows

Hi all,

I have written a Yii console command that pulls a lot of records from the database and then processes each one. This processing time takes up to a minute.

If a row in this set is changed in the database by a user, does that change get reflected in the rows being worked on by the console app? I guess what I am asking is when a recordset is created in ActiveRecord are all the rows read into the application’s memory or are they fetched from the database when needed.

I am using mysql.

Thanks.

Hello Dan,

this is the wrong section for such a question. You are posting in the "Feature Requests" Board.

However - Because I do not fully understand your question, you might should turn on CDbConnection::enableProfiling and an appropriate logging method to see whats going on and which statements are executed.

NOTE: moved to proper section