When the PHPYii framework updates multiple data entries, it is easy for the webpage to time out. For example, when I want to update many tables, the webpage may easily Time Out. PLMH1: model ()-& gt; updateAll (array (VISITNUM & gt; V. $ _ POST [inputNum]), SUBJ, array (: subjid php Yii Framework is prone to webpage timeout when multiple data entries are updated.
If I want to update many tables, it is easy for the webpage to time out.
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 ));
The error message is as follows:
Fatal error: Maximum execution time of 30 seconds exceeded in D: \ web_root \ rd1039b \ framework \ db \ CDbCommand. php on line 496
Does YII have other fast update methods?
Thank you!
Framework