yii2.0 query database to reduce memory usage

yii2.0 query database to reduce memory usage

1. Query result conversion Array (object in memory occupies more than array high where () plus->asarray () to convert the object to an arrays)

$results = Test::find ()->where ([' Between ', ' ID ',])->all (); The print result is an object

$results = Test::find ()->where ([' Between ', ' ID ', up])->asarray ()->all (); The printed result is an array

2. Batch query (circular query, more cycles, more SQL statements, poor performance | Batch query more than one query, reduce the number of cycles, good performance, save memory)

foreach (Test::find ()->batch () as $tests)//20 data per query to $tests
{
Print_r (Count ($tests));
}

yii2.0 query database to reduce memory usage