Online PHP editor | perf for bTOn1

<?php /** * SAE Mysql服务 * * 支持主从分离 * * @author Easychen <easychen@gmail.com> * @version $Id$ * @package sae * */ /** * Sae Mysql Class * * <code> * <?php * $mysql = new SaeMysql(); * * $sql = "SELECT * FROM `user` LIMIT 10"; * $data = $mysql->getData( $sql ); * $name = strip_tags( $_REQUEST['name'] ); * $age = intval( $_REQUEST['age'] ); * $sql = "INSERT INTO `user` ( `name` , `age` , `regtime` ) VALUES ( '" . $mysql->escape( $name ) . "' , '" . intval( $age ) . "' , NOW() ) "; * $mysql->runSql( $sql ); * if( $mysql->errno() != 0 ) * { * die( "Error:" . $mysql->errmsg() ); * } * * $mysql->closeDb(); * ?> * </code> * * @package sae * @author EasyChen * */ class SaeMysql extends SaeObject { /** * 构造函数 * * @param bool $do_replication 是否支持主从分离，true:支持，false:不支持，默认为true * @return void * @author EasyChen */ function __construct( $do_replication = true ) { $this->port = 3307; $this->host = '.rdc.sae.sina.com.cn'; $this->accesskey = SAE_ACCESSKEY; $this->secretkey = SAE_SECRETKEY; $this->appname = 'app_' . $_SERVER['HTTP_APPNAME']; //set default charset as utf8 $this->charset = 'UTF8'; $this->do_replication = $do_replication; } /** * 设置keys * * 当需要连接其他APP的数据库时使用 * * @param string $akey AccessKey * @param string $skey SecretKey * @return void * @author EasyChen */ public function setAuth( $akey , $skey ) { $this->accesskey = $akey; $this->secretkey = $skey; } /** * 设置Mysql服务器端口 * * 当需要连接其他APP的数据库时使用 * * @param string $port * @return void * @author EasyChen */ public function setPort( $port ) { $this->port = 3307; $this->host = '.rdc.sae.sina.com.cn'; } /** * 设置Appname * * 当需要连接其他APP的数据库时使用 * * @param string $appname * @return void * @author EasyChen */ public function setAppname( $appname ) { $this->appname = 'app_' . $appname; } /** * 设置当前连接的字符集 , 必须在发起连接之前进行设置 * * @param string $charset 字符集,如GBK,GB2312,UTF8 * @return void */ public function setCharset( $charset ) { return $this->set_charset( $charset ); } /** * 同setCharset,向前兼容 * * @param string $charset * @return void * @ignore */ public function set_charset( $charset ) { $this->charset = $charset; } /** * 运行Sql语句,不返回结果集 * * @param string $sql * @return mysqli_result|bool */ public function runSql( $sql ) { return $this->run_sql( $sql ); } /** * 同runSql,向前兼容 * * @param string $sql * @return bool * @author EasyChen * @ignore */ public function run_sql( $sql ) { $this->last_sql = $sql; $dblink = $this->db_write(); if ($dblink === false) { return false; } $ret = mysqli_query( $dblink, $sql ); $this->save_error( $dblink ); return $ret; } /** * 运行Sql,以多维数组方式返回结果集 * * @param string $sql * @return array 成功返回数组，失败时返回false * @author EasyChen */ public function getData( $sql ) { return $this->get_data( $sql ); } /** * 同getData,向前兼容 * * @ignore */ public function get_data( $sql ) { $this->last_sql = $sql; $data = Array(); $i = 0; $dblink = $this->do_replication ? $this->db_read() : $this->db_write(); if ($dblink === false) { return false; } $result = mysqli_query( $dblink , $sql ); $this->save_error( $dblink ); if (is_bool($result)) { return $result; } else { while( $Array = mysqli_fetch_array( $result, MYSQL_ASSOC ) ) { $data[$i++] = $Array; } } mysqli_free_result($result); if( count( $data ) > 0 ) return $data; else return NULL; } /** * 运行Sql,以数组方式返回结果集第一条记录 * * @param string $sql * @return array 成功返回数组，失败时返回false * @author EasyChen */ public function getLine( $sql ) { return $this->get_line( $sql ); } /** * 同getLine,向前兼容 * * @param string $sql * @return array * @author EasyChen * @ignore */ public function get_line( $sql ) { $data = $this->get_data( $sql ); if ($data) { return @reset($data); } else { return false; } } /** * 运行Sql,返回结果集第一条记录的第一个字段值 * * @param string $sql * @return mixxed 成功时返回一个值，失败时返回false * @author EasyChen */ public function getVar( $sql ) { return $this->get_var( $sql ); } /** * 同getVar,向前兼容 * * @param string $sql * @return array * @author EasyChen * @ignore */ public function get_var( $sql ) { $data = $this->get_line( $sql ); if ($data) { return $data[ @reset(@array_keys( $data )) ]; } else { return false; } } /** * 同mysqli_affected_rows函数 * * @return int 成功返回行数,失败时返回-1 * @author Elmer Zhang */ public function affectedRows() { $result = isset($this->db_write) ? mysqli_affected_rows( $this->db_write ) : -1; return $result; } /** * 同mysqli_insert_id函数 * * @return int 成功返回last_id,失败时返回false * @author EasyChen */ public function lastId() { return $this->last_id(); } /** * 同lastId,向前兼容 * * @return int * @author EasyChen * @ignore */ public function last_id() { $result = mysqli_insert_id( $this->db_write( false ) ); return $result; } /** * 关闭数据库连接 * * @return bool * @author EasyChen */ public function closeDb() { return $this->close_db(); } /** * 同closeDb,向前兼容 * * @return bool * @author EasyChen * @ignore */ public function close_db() { if( isset( $this->db_read ) ) @mysqli_close( $this->db_read ); if( isset( $this->db_write ) ) @mysqli_close( $this->db_write ); } /** * 同mysqli_real_escape_string * * @param string $str * @return string * @author EasyChen */ public function escape( $str ) { if( isset($this->db_read) ) { $db = $this->db_read; } elseif( isset($this->db_write) ) { $db = $this->db_write; } else { $db = $this->db_read(); } return mysqli_real_escape_string( $db , $str ); } /** * 返回错误码 * * * @return int * @author EasyChen */ public function errno() { return $this->errno; } /** * 返回错误信息 * * @return string * @author EasyChen */ public function error() { return $this->error; } /** * 返回错误信息,error的别名 * * @return string * @author EasyChen */ public function errmsg() { return $this->error(); } /** * @ignore */ private function connect( $is_master = true ) { if ($this->port == 0) { $this->error = 13048; $this->errno = 'Not Initialized'; return false; } if( $is_master ) $host = 'w' . $this->host; else $host = 'r' . $this->host; $db = mysqli_init(); mysqli_options($db, MYSQLI_OPT_CONNECT_TIMEOUT, 5); if( !mysqli_real_connect( $db, $host , $this->accesskey , $this->secretkey , $this->appname , $this->port ) ) { $this->error = mysqli_connect_error(); $this->errno = mysqli_connect_errno(); return false; } mysqli_set_charset( $db, $this->charset); return $db; } /** * @ignore */ private function db_read() { if( isset( $this->db_read ) && mysqli_ping( $this->db_read ) ) { return $this->db_read; } else { if( !$this->do_replication ) return $this->db_write(); else { $this->db_read = $this->connect( false ); return $this->db_read; } } } /** * @ignore */ private function db_write( $reconnect = true ) { if( isset( $this->db_write ) && ( $reconnect == false || mysqli_ping( $this->db_write ) ) ) { return $this->db_write; } else { $this->db_write = $this->connect( true ); return $this->db_write; } } /** * @ignore */ private function save_error($dblink) { $this->error = mysqli_error($dblink); $this->errno = mysqli_errno($dblink); } private $error; private $errno; private $last_sql; } //Documentation generated on Tue, 25 Feb 2014 21:24:45 +0800 by phpDocumentor 1.4.3 $mysql = new SaeMysql();//sae内部类链接数据 $num = "SELECT * FROM `message` "; $mysql->runSql($num); $no=$mysql->affectedRows();//获取行数 echo $no; printf($no);

Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).

Version	System time (s)	User time (s)	Memory (MiB)
8.3.6	0.011	0.011	18.43
8.3.5	0.016	0.003	21.95
8.3.4	0.012	0.003	19.01
8.3.3	0.007	0.007	19.16
8.3.2	0.003	0.006	20.16
8.3.1	0.006	0.003	21.79
8.3.0	0.000	0.008	22.40
8.2.18	0.012	0.009	16.85
8.2.17	0.010	0.010	22.96
8.2.16	0.004	0.011	22.21
8.2.15	0.004	0.004	24.18
8.2.14	0.008	0.000	24.66
8.2.13	0.008	0.000	26.16
8.2.12	0.004	0.004	17.75
8.2.11	0.007	0.003	19.39
8.2.10	0.003	0.009	17.90
8.2.9	0.004	0.004	19.31
8.2.8	0.000	0.008	17.97
8.2.7	0.006	0.003	17.63
8.2.6	0.008	0.000	17.80
8.2.5	0.007	0.003	18.09
8.2.4	0.006	0.003	20.61
8.2.3	0.000	0.008	19.52
8.2.2	0.003	0.005	17.86
8.2.1	0.000	0.008	17.88
8.2.0	0.004	0.004	17.70
8.1.28	0.014	0.000	25.92
8.1.27	0.004	0.004	22.19
8.1.26	0.004	0.004	26.35
8.1.25	0.004	0.004	28.09
8.1.24	0.006	0.003	22.52
8.1.23	0.000	0.011	17.77
8.1.22	0.000	0.008	17.74
8.1.21	0.003	0.005	18.77
8.1.20	0.008	0.003	17.48
8.1.19	0.000	0.009	17.35
8.1.18	0.005	0.003	18.10
8.1.17	0.005	0.003	18.76
8.1.16	0.000	0.007	20.65
8.1.15	0.004	0.004	18.66
8.1.14	0.005	0.003	17.41
8.1.13	0.002	0.005	17.86
8.1.12	0.000	0.007	17.45
8.1.11	0.000	0.008	17.36
8.1.10	0.003	0.005	17.30
8.1.9	0.005	0.005	17.47
8.1.8	0.004	0.004	17.47
8.1.7	0.005	0.002	17.47
8.1.6	0.003	0.005	17.59
8.1.5	0.009	0.000	17.45
8.1.4	0.003	0.005	17.43
8.1.3	0.000	0.008	17.59
8.1.2	0.000	0.008	17.69
8.1.1	0.004	0.004	17.59
8.1.0	0.008	0.000	17.42
8.0.30	0.004	0.004	18.77
8.0.29	0.004	0.004	17.00
8.0.28	0.000	0.008	18.50
8.0.27	0.003	0.003	17.33
8.0.26	0.003	0.003	17.05
8.0.25	0.007	0.000	17.11
8.0.24	0.000	0.008	17.07
8.0.23	0.005	0.003	17.12
8.0.22	0.005	0.002	16.93
8.0.21	0.004	0.004	17.06
8.0.20	0.002	0.005	17.16
8.0.19	0.000	0.009	17.11
8.0.18	0.002	0.005	17.10
8.0.17	0.003	0.005	16.95
8.0.16	0.000	0.008	17.07
8.0.15	0.000	0.007	16.93
8.0.14	0.004	0.004	17.02
8.0.13	0.000	0.006	13.44
8.0.12	0.008	0.000	17.02
8.0.11	0.000	0.007	17.04
8.0.10	0.006	0.003	17.05
8.0.9	0.007	0.000	16.94
8.0.8	0.006	0.009	17.02
8.0.7	0.003	0.005	17.06
8.0.6	0.000	0.008	17.07
8.0.5	0.004	0.004	16.97
8.0.3	0.011	0.008	17.03
8.0.2	0.013	0.005	17.40
8.0.1	0.000	0.009	16.97
8.0.0	0.010	0.008	16.74
7.4.33	0.007	0.000	15.00
7.4.32	0.004	0.004	16.52
7.4.30	0.004	0.004	16.61
7.4.29	0.003	0.003	16.47
7.4.28	0.000	0.007	16.53
7.4.27	0.003	0.003	16.43
7.4.26	0.007	0.000	16.51
7.4.25	0.000	0.008	16.38
7.4.24	0.002	0.005	16.62
7.4.23	0.004	0.004	16.71
7.4.22	0.006	0.012	16.54
7.4.21	0.008	0.009	16.62
7.4.20	0.007	0.000	16.46
7.4.19	0.000	0.007	16.42
7.4.16	0.013	0.010	16.42
7.4.15	0.012	0.006	17.40
7.4.14	0.009	0.008	17.86
7.4.13	0.009	0.008	16.71
7.4.12	0.015	0.005	16.58
7.4.11	0.013	0.010	16.38
7.4.10	0.009	0.009	16.69
7.4.9	0.013	0.010	16.63
7.4.8	0.013	0.007	19.39
7.4.7	0.015	0.003	16.62
7.4.6	0.011	0.007	16.52
7.4.5	0.004	0.004	16.51
7.4.4	0.006	0.009	22.77
7.4.3	0.008	0.008	16.41
7.4.0	0.003	0.012	15.23
7.3.33	0.003	0.003	13.26
7.3.32	0.005	0.000	13.36
7.3.31	0.005	0.002	16.20
7.3.30	0.003	0.003	16.36
7.3.29	0.003	0.017	16.39
7.3.28	0.008	0.009	16.38
7.3.27	0.009	0.009	17.40
7.3.26	0.010	0.007	16.52
7.3.25	0.014	0.003	16.46
7.3.24	0.012	0.006	16.57
7.3.23	0.014	0.004	16.44
7.3.21	0.003	0.013	16.36
7.3.20	0.013	0.003	19.39
7.3.19	0.003	0.017	16.55
7.3.18	0.009	0.006	16.43
7.3.17	0.010	0.006	16.50
7.3.16	0.011	0.006	16.48
7.3.12	0.007	0.007	14.68
7.3.1	0.000	0.015	16.47
7.3.0	0.009	0.006	16.41
7.2.33	0.007	0.011	16.48
7.2.32	0.016	0.006	16.63
7.2.31	0.007	0.010	16.66
7.2.30	0.004	0.012	16.69
7.2.29	0.012	0.009	16.43
7.2.13	0.006	0.012	16.64
7.2.12	0.003	0.014	16.80
7.2.11	0.009	0.006	16.62
7.2.10	0.000	0.011	16.48
7.2.9	0.007	0.011	16.86
7.2.8	0.010	0.006	16.70
7.2.7	0.007	0.010	16.76
7.2.6	0.004	0.008	16.61
7.2.5	0.004	0.011	16.79
7.2.4	0.013	0.000	16.75
7.2.3	0.006	0.003	16.59
7.2.2	0.007	0.010	16.79
7.2.1	0.000	0.010	16.43
7.2.0	0.006	0.013	16.74
7.1.25	0.003	0.012	15.41
7.1.20	0.009	0.003	15.29
7.1.7	0.003	0.006	17.08
7.1.6	0.010	0.016	19.82
7.1.5	0.011	0.014	16.86
7.1.0	0.007	0.070	22.44
7.0.20	0.008	0.003	16.62
7.0.14	0.010	0.070	21.95
7.0.10	0.043	0.077	20.02
7.0.9	0.047	0.070	20.05
7.0.8	0.043	0.073	20.05
7.0.7	0.020	0.047	20.05
7.0.6	0.020	0.077	20.14
7.0.5	0.047	0.073	20.41
7.0.4	0.003	0.067	20.10
7.0.3	0.000	0.073	20.14
7.0.2	0.007	0.073	20.15
7.0.1	0.013	0.080	20.04
7.0.0	0.013	0.073	20.17
5.6.28	0.007	0.070	21.05
5.6.25	0.010	0.077	20.56
5.6.24	0.017	0.067	20.73
5.6.23	0.010	0.077	20.75
5.6.22	0.017	0.067	20.71
5.6.21	0.003	0.083	20.53
5.6.20	0.007	0.087	21.20
5.6.19	0.003	0.077	21.10
5.6.18	0.017	0.067	21.08
5.6.17	0.007	0.070	21.14
5.6.16	0.003	0.070	21.19
5.6.15	0.003	0.083	21.09
5.6.14	0.003	0.073	21.11
5.6.13	0.007	0.083	21.14
5.6.12	0.010	0.070	21.11
5.6.11	0.007	0.087	21.11
5.6.10	0.007	0.083	21.01
5.6.9	0.007	0.050	21.11
5.6.8	0.000	0.087	20.62
5.6.7	0.007	0.080	20.46
5.6.6	0.007	0.067	20.53
5.6.5	0.010	0.070	20.53
5.6.4	0.027	0.053	20.59
5.6.3	0.007	0.070	20.39
5.6.2	0.007	0.060	20.47
5.6.1	0.010	0.073	20.46
5.6.0	0.007	0.080	20.48
5.5.38	0.007	0.080	20.46
5.5.37	0.013	0.073	20.46
5.5.36	0.003	0.060	20.42
5.5.35	0.003	0.070	20.50
5.5.34	0.007	0.080	20.80
5.5.33	0.013	0.077	20.83
5.5.32	0.013	0.073	20.99
5.5.31	0.007	0.080	20.86
5.5.30	0.010	0.080	20.84
5.5.29	0.023	0.053	20.89
5.5.28	0.003	0.043	20.93
5.5.27	0.017	0.073	20.77
5.5.26	0.007	0.090	20.82
5.5.25	0.013	0.077	20.80
5.5.24	0.020	0.067	20.21
5.5.23	0.013	0.067	20.30
5.5.22	0.007	0.083	20.23
5.5.21	0.007	0.067	20.08
5.5.20	0.007	0.080	20.28
5.5.19	0.007	0.073	20.19
5.5.18	0.003	0.080	20.30
5.5.16	0.007	0.077	20.21
5.5.15	0.003	0.083	20.14
5.5.14	0.007	0.077	20.24
5.5.13	0.013	0.070	20.18
5.5.12	0.017	0.060	20.31
5.5.11	0.010	0.077	20.31
5.5.10	0.020	0.063	20.18
5.5.9	0.007	0.080	20.13
5.5.8	0.013	0.067	20.22
5.5.7	0.003	0.040	20.06
5.5.6	0.010	0.060	20.12
5.5.5	0.017	0.067	19.99
5.5.4	0.010	0.050	20.17
5.5.3	0.010	0.070	20.08
5.5.2	0.007	0.047	20.11
5.5.1	0.017	0.067	20.02
5.5.0	0.010	0.077	20.16
5.4.45	0.010	0.043	19.23
5.4.44	0.013	0.077	19.39
5.4.43	0.010	0.073	19.23
5.4.42	0.017	0.047	19.50
5.4.41	0.017	0.063	19.14
5.4.40	0.007	0.070	18.95
5.4.39	0.007	0.070	19.05
5.4.38	0.003	0.083	19.05
5.4.37	0.000	0.080	18.85
5.4.36	0.003	0.070	19.04
5.4.35	0.010	0.040	19.13
5.4.34	0.003	0.083	19.21
5.4.32	0.003	0.053	19.14
5.4.31	0.007	0.043	19.09
5.4.30	0.007	0.067	18.87
5.4.29	0.003	0.077	18.84
5.4.28	0.003	0.040	19.09
5.4.27	0.007	0.077	18.90
5.4.26	0.003	0.070	18.90
5.4.25	0.003	0.067	19.20
5.4.24	0.003	0.077	18.86
5.4.23	0.017	0.053	19.03
5.4.22	0.013	0.057	18.87
5.4.21	0.013	0.067	18.84
5.4.20	0.010	0.070	19.16
5.4.19	0.010	0.070	19.02
5.4.18	0.007	0.083	19.11
5.4.17	0.007	0.053	18.84
5.4.16	0.013	0.063	18.86
5.4.15	0.000	0.080	19.11
5.4.14	0.000	0.070	16.45
5.4.13	0.007	0.040	16.32
5.4.12	0.003	0.080	16.41
5.4.11	0.010	0.077	16.38
5.4.10	0.007	0.050	16.49
5.4.9	0.007	0.033	16.52
5.4.8	0.010	0.060	16.51
5.4.7	0.013	0.063	16.43
5.4.6	0.007	0.067	16.50
5.4.5	0.010	0.057	16.53
5.4.4	0.010	0.063	16.53
5.4.3	0.007	0.070	16.52
5.4.2	0.013	0.063	16.41
5.4.1	0.013	0.047	16.36
5.4.0	0.010	0.067	15.84
5.3.29	0.003	0.073	14.67
5.3.28	0.003	0.080	14.79
5.3.27	0.013	0.070	14.70
5.3.26	0.007	0.057	14.68
5.3.25	0.007	0.063	14.77
5.3.24	0.013	0.047	14.66
5.3.23	0.007	0.067	14.77
5.3.22	0.003	0.050	14.62
5.3.21	0.003	0.060	14.75
5.3.20	0.010	0.070	14.75
5.3.19	0.010	0.067	14.64
5.3.18	0.003	0.077	14.69
5.3.17	0.003	0.080	14.75
5.3.16	0.010	0.037	14.67
5.3.15	0.000	0.063	14.57
5.3.14	0.000	0.083	14.61
5.3.13	0.007	0.070	14.69
5.3.12	0.010	0.043	14.71
5.3.11	0.013	0.070	14.59
5.3.10	0.007	0.080	14.20
5.3.9	0.020	0.057	14.05
5.3.8	0.010	0.073	14.04
5.3.7	0.000	0.047	13.98
5.3.6	0.010	0.067	14.01
5.3.5	0.000	0.073	14.07
5.3.4	0.007	0.033	14.07
5.3.3	0.010	0.047	13.86
5.3.2	0.017	0.057	13.88
5.3.1	0.010	0.073	13.66
5.3.0	0.000	0.060	13.64