Magento Articles and Tips for Developers

        $tableDataCollection = Mage::getResourceModel('modulename/tablename_collection')->setPageSize(50);
 
	// Set number of pages and current page
        $pages = $tableDataCollection->getLastPageNumber();
        $currentPage = 1;
 
	// Interate
        do {
            $tableDataCollection->setCurPage($currentPage);
            $tableDataCollection->load();
 
            foreach ($tableDataCollection as $tableRow) {
		echo $tableRow->getId()."\n";
            }
 
            $currentPage++;
 
            //Clear collection and free memory
            $tableDataCollection->clear();
        } while ($pages => $currentPage);