batch query

batch-query.php

<?php

$itemsPerRequest = 50;
$itemsCriteria = array(
    'condition' => 't.type = 2 AND t.isDeleted != 1 AND t.isActive = 1 AND t.itemType = 1000',
    'order'     => 'id ASC',
    'limit'     => $itemsPerRequest,
    'offset'    => 0,
);
$i = 0;
echo 'Adding items list to xml', PHP_EOL;
while (count($items = Catalog::model()->findAll($itemsCriteria)) > 0) {
    $yml = $this->insertYmlItems($yml, $items);
    $itemsCriteria['offset'] += $itemsPerRequest;
    //$i += $itemsPerRequest;
    //if ($i > 100) break;
}