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

Foreach嵌套Foreach速度慢優(yōu)化?案有時候這樣的效率還可以，但是只要牽涉到操作數(shù)據庫，那就GAMEOVER。。最近在維護項?，?個Foreach循環(huán)，4分半才能出來結果。代碼：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);}}查詢時候在群中這個操作極慢?。?！數(shù)據庫已經添加索引。。?？紤]?戶量太?，?且沒有緩沖機制。只能?次次讀庫。修改優(yōu)化?案：將循環(huán)查詢和插?改為批量操作。減少操作數(shù)據庫次數(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();//根據java接??戶名，批量查詢?戶是否存在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);//不存在的?戶if($nouser){//?戶不存在foreach($nouseras$key=>$val){$dataList[]=array('username'=>$val,'password'=>'wanxue','pid'=>9,'type'=>3);//要批量插?的數(shù)據$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',$