php yii框架更新多条数据时容易网页超时。
如我要更新很多表时,网页容易超时
plmh1::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
plmh2::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
plmh3::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
plmh4::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
plmh5::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
plmh6::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
plmh7::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
plmh8::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
plsu::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
plpe::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
pllb1::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
pllb2::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
pllb3::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
pllb4::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
pllb5::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
pllb6::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
pllb7::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
pllb8::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
plco::model()->updateall(array('visitnum'=>'v'.$_post['inputnum']),'subjid=:subjid and visitnum=:visitnum',array(':subjid'=>$subjid,':visitnum'=>$visitnum));
错识提示如下:
fatal error: maximum execution time of 30 seconds exceeded in d:\web_root\rd1039b\framework\db\cdbcommand.php on line 496
请问yii有其它比较快的更新方法吗?
谢谢!
框架