Foreach嵌套Foreach速度慢優(yōu)化方案

Foreach嵌套Foreach速度慢優(yōu)化?案有時(shí)候這樣的效率還可以，但是只要牽涉到操作數(shù)據(jù)庫(kù)，那就GAMEOVER。。最近在維護(hù)項(xiàng)?，?個(gè)Foreach循環(huán)，4分半才能出來(lái)結(jié)果。代碼：foreach($contentas$key=>$val){$user=$userModel->where(array('username'=>$val))->Field('id,username')->find();if($user){//查找群?是否存在if(!$ck_group_userModel->where(array('uid'=>$user['id']))->Field('uid')->find()){$data[]=array('id'=>$user['id'],'username'=>$user['username']);}}else{$id=$userModel->add(array('username'=>$val,'password'=>1234,'pid'=>9,'type'=>3));$data[]=array('id'=>$id,'username'=>$val);}}查詢(xún)時(shí)候在群中這個(gè)操作極慢?。?！數(shù)據(jù)庫(kù)已經(jīng)添加索引。。。考慮?戶(hù)量太?，?且沒(méi)有緩沖機(jī)制。只能?次次讀庫(kù)。修改優(yōu)化?案：將循環(huán)查詢(xún)和插?改為批量操作。減少操作數(shù)據(jù)庫(kù)次數(shù)。優(yōu)化代碼：$userModel=M('user');$ck_group_userModel=M('ck_group_user');$data=array();$where['username']=array('in',$content);$user=$userModel->where($where)->Field('id,username')->select();//根據(jù)java接??戶(hù)名，批量查詢(xún)?戶(hù)是否存在for($i=0;$i<count($user);$i++){$userid[$i]=$user[$i]['id'];$newuser[$i]=$user[$i]['username'];}$newuser=array_flip($newuser);$newuser=array_flip($newuser);//去重$nouser=array_diff($content,$newuser);//不存在的?戶(hù)if($nouser){//?戶(hù)不存在foreach($nouseras$key=>$val){$dataList[]=array('username'=>$val,'password'=>'wanxue','pid'=>9,'type'=>3);//要批量插?的數(shù)據(jù)$userModel->addAll($dataList);}$con1['username']=array('in',$nouser);$con1['pid']=array('eq',$college_name['region_id']);$data=$userModel->where($con1)->Field('id,username')->select();}else{//查找群?是否存在$con2['uid']=array('in',$userid);$ingroup=$ck_group_userModel->distinct(true)->Field('uid')->select();for($i=0;$i<count($ingroup);$i++){$ingroup[$i]=$ingroup[$i]['uid'];}$nogroup=array_diff($userid,$ingroup);$con3['id']=array('in',$