php - using full zend query in while loop.And in loop i execute full query and merge them in one array -

optimize zend query takes time execute. using full zend query in while loop.and in loop execute full query , merge them in 1 array .. @ have 1 array results takes time execute .. below exact case

while($str){     $db = zend_registry::get('dbadapter');     $select = new zend_db_select($db);         $select = $db->select();      // business logic omitted       $stmt = $select->query();     $result = $stmt->fetchall();      // after execution merge record in new array ( $final_result )     $temp_arr =  $result;     $final_result = array_merge($final_result,$temp_arr);     unset($temp_arr); } 

you don't have write following code inside loop, write them outside loop...

$db = zend_registry::get('dbadapter'); $select = new zend_db_select($db);   $select = $db->select(); $stmt = $select->query(); 

then write following code inside loop:

$result = $stmt->fetchall();  $final_result[] = $result;  unset($result); 

this code might you.......