Online PHP editor | perf for pNom8

<?php define("STATE_ID","3"); define("DATA_CACHE_TIMEOUT","9999"); class ImportController extends Controller { public function actionIndex() { $t1=date("r"); $ts1=microtime(true); $tot=0; echo "\r\n ******** Started at $t1 ******** \r\n"; $connection = Yii::app()->db; $command = $connection->createCommand('SELECT * FROM seccsirsa LIMIT 0,10'); $rows = $command->queryAll(); //executes the SQL statement and returns the first row of the //$res = array(); foreach ($rows as $row) { extract($row); echo "\r\nFull Name: $Name_en ($Name_h) \r\n"; //echo " ".$this->getDistId($District."DEL"); echo " ".$this->getDistId($District); } $t2=date("r"); $ts2=microtime(true); $diff=($ts2-$ts1); echo "\r\n ******** Stopped at $t2 ******** \r\n"; echo "\r\n ******** Total Execution Time: $diff microseconds ******** \r\n"; echo "\r\n ******** Total Records Imported: $tot ******** \r\n"; } private function getDistId($District){ //Select if record exists $District=trim(strtolower($District)); $connection = Yii::app()->db; $connection->active=true; $command = $connection->createCommand("SELECT LR_ID FROM tblLandRegion WHERE lower(LR_Name) = '$District' AND LR_Type='District' "); $row = $command->queryRow(); //If no record found if($row===false){ //Insert record in DB (Master Table) $command = $connection->createCommand("INSERT INTO tblLandRegion (LR_Name,LR_Type) VALUES('$District', 'District') "); $rowCount=$command->execute(); if($rowCount==0){ die("FATAL ERROR 0x01: Failed to insert $District in Master table :: ".__FILE__." at line nunber ."__LINE__); } else{ //Cache and Return the PK/ID of the new inserted record. $row = Yii::app()->cache->get('cache_'.$District."_".STATE_ID); if (($row === false) || row($res)) { $District=trim(strtolower($District)); $connection = Yii::app()->db; $command = $connection->createCommand("SELECT LR_ID FROM tblLandRegion WHERE lower(LR_Name) = '$District' AND LR_Type='District' ORDER BY LR_ID DESC"); $row = $command->queryRow(); Yii::app()->cache->set('cache_'.$District."_".STATE_ID, $row, DATA_CACHE_TIMEOUT); } $District_ID=$row['LR_ID']; //Insert record in DB (Reference Table) $command = $connection->createCommand("INSERT INTO tblDistrict (District_ID, State_ID) VALUES('$District_ID', '".STATE_ID."') "); $rowCount=$command->execute(); if($rowCount==0){ die("FATAL ERROR 0x02: Failed to insert $District in Reference table :: ".__FILE__." at line nunber ."__LINE__); } return $District_ID; } } else{ //Return the PK/ID of the record. return $row['LR_ID']; } } } ?>

Version	System time (s)	User time (s)	Memory (MiB)
5.4.27	0.010	0.042	12.39
5.4.26	0.009	0.043	12.39
5.4.25	0.009	0.043	12.39
5.4.24	0.010	0.040	12.39
5.4.23	0.007	0.052	12.38
5.4.22	0.011	0.046	12.38
5.4.21	0.008	0.043	12.38
5.4.20	0.009	0.049	12.38
5.4.19	0.005	0.043	12.38
5.4.18	0.014	0.041	12.38
5.4.17	0.017	0.049	12.39
5.4.16	0.004	0.039	12.38
5.4.15	0.009	0.040	12.38
5.4.14	0.009	0.041	12.07
5.4.13	0.009	0.036	12.05
5.4.12	0.009	0.042	12.02
5.4.11	0.009	0.047	12.01
5.4.10	0.010	0.038	12.01
5.4.9	0.012	0.051	12.01
5.4.8	0.008	0.047	12.01
5.4.7	0.010	0.045	12.01
5.4.6	0.009	0.036	12.01
5.4.5	0.007	0.038	12.01
5.4.4	0.007	0.038	12.00
5.4.3	0.011	0.056	11.99
5.4.2	0.011	0.040	11.99
5.4.1	0.009	0.049	11.99
5.4.0	0.008	0.050	11.49
5.3.28	0.011	0.042	12.71
5.3.27	0.007	0.051	12.72
5.3.26	0.007	0.041	12.72
5.3.25	0.014	0.049	12.72
5.3.24	0.012	0.046	12.72
5.3.23	0.011	0.043	12.71
5.3.22	0.011	0.045	12.68
5.3.21	0.007	0.050	12.68
5.3.20	0.009	0.041	12.68
5.3.19	0.009	0.046	12.68
5.3.18	0.012	0.051	12.67
5.3.17	0.011	0.041	12.67
5.3.16	0.012	0.047	12.67
5.3.15	0.010	0.045	12.67
5.3.14	0.009	0.038	12.66
5.3.13	0.010	0.043	12.66
5.3.12	0.009	0.045	12.66
5.3.11	0.009	0.040	12.66
5.3.10	0.011	0.043	12.12
5.3.9	0.008	0.040	12.09
5.3.8	0.007	0.038	12.08
5.3.7	0.009	0.039	12.08
5.3.6	0.008	0.038	12.06
5.3.5	0.007	0.039	12.00
5.3.4	0.006	0.039	12.00
5.3.3	0.006	0.043	11.97
5.3.2	0.007	0.038	11.75
5.3.1	0.009	0.035	11.71
5.3.0	0.006	0.037	11.70