Online PHP editor | perf for HivEd

@ 2023-12-10T05:33:11Z

<?php

// 実行
$testNestedTransactions = new TestNestedTransactions();
$testNestedTransactions->createTables(); // CREATE TABLE
$result = $testNestedTransactions->insert(); // INSERT
echo "<p>{$result}</p>"; // 結果

// データベース接続
final class Database
{
    private static array $instances = [];

    // データベース接続
    final public static function getInstance(string $name): \PDO
    {
        if (!isset(self::$instances[$name])) {
            // データベース接続情報
            $config = [
                'db1' => [
                    'dsn' => 'mysql:host=localhost;dbname=mydb1',
                    'username' => 'myuser1',
                    'password' => 'mypassword1'
                ]
            ];

            if (!isset($config[$name])) {
                throw new \DomainException(json_encode_noesc_slashes([
                    'message' => 'Invalid database name: ' . $name
                ]));
            }
            $dbConfig = $config[$name];
            $dsn = $dbConfig['dsn'];
            $username = $dbConfig['username'];
            $password = $dbConfig['password'];
            self::$instances[$name] = new \PDO($dsn, $username, $password);
        }
        return self::$instances[$name];
    }
}

// 入れ子のトランザクション
final class TestNestedTransactions
{
    private \PDO $pdo;

    public function __construct()
    {
        $this->pdo = Database::getInstance('db1');
    }

    // テーブル作成
    final public function createTables(): void
    {
        try {
            $this->pdo->query("
                CREATE TABLE IF NOT EXISTS test_table1 (
                    id INT AUTO_INCREMENT PRIMARY KEY,
                    column1 VARCHAR(255) NOT NULL
                )
            ");
            $this->pdo->query("
                CREATE TABLE IF NOT EXISTS test_table2 (
                    id INT AUTO_INCREMENT PRIMARY KEY,
                    column2 VARCHAR(255) NOT NULL
                )
            ");

        } catch (\PDOException $e) {
            echo $e->getMessage();
        }
    }

    // 入れ子のトランザクションで INSERT を実行
    final public function insert(): string
    {
        try {
            // 外側のトランザクション開始
            $this->pdo->beginTransaction();

            // test_table1 の INSERT を実行
            $stmt1 = $this->pdo->prepare("INSERT INTO test_table1 (column1) VALUES (:value1)");
            $value1 = 'some_value_1';
            $stmt1->bindParam(':value1', $value1);
            $stmt1->execute();

            try {
                // 入れ子のトランザクション開始
                $this->pdo->beginTransaction();

                // test_table2 の INSERT を実行
                $stmt2 = $this->pdo->prepare("INSERT INTO test_table2 (column2) VALUES (:value2)");
                $value2 = 'some_value_2';
                $stmt2->bindParam(':value2', $value2);
                $stmt2->execute();

                // 入れ子のトランザクションのコミット
                $this->pdo->commit();
            } catch (\Exception $e) {
                // 入れ子のトランザクションのロールバック
                $this->pdo->rollBack();
                throw $e;
            }

            // 外側のトランザクションのコミット
            $this->pdo->commit();

            return "成功";
        } catch (\Exception $e) {
            // 外側のトランザクションのロールバック
            $this->pdo->rollBack(); // この行でエラーが発生
            return "エラー: " . $e->getMessage();
        }
    }
}

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.5.0	0.016	0.008	19.96
8.4.15	0.001	0.001	14.05
8.4.14	0.011	0.009	17.72
8.4.13	0.004	0.005	17.76
8.4.12	0.014	0.006	20.30
8.4.11	0.012	0.009	22.49
8.4.10	0.013	0.008	17.95
8.4.9	0.005	0.005	18.83
8.4.8	0.013	0.006	17.78
8.4.7	0.005	0.005	18.16
8.4.6	0.005	0.004	18.11
8.4.5	0.005	0.005	17.80
8.4.4	0.013	0.007	17.82
8.4.3	0.016	0.003	18.96
8.4.2	0.015	0.000	18.95
8.4.1	0.003	0.016	19.68
8.3.28	0.014	0.010	18.37
8.3.27	0.009	0.010	16.54
8.3.26	0.009	0.012	16.66
8.3.25	0.009	0.010	19.22
8.3.24	0.013	0.007	16.40
8.3.23	0.011	0.009	16.67
8.3.22	0.006	0.011	17.05
8.3.21	0.011	0.007	16.72
8.3.20	0.004	0.004	16.65
8.3.19	0.003	0.005	16.70
8.3.18	0.012	0.007	18.23
8.3.17	0.016	0.003	18.73
8.3.16	0.010	0.007	20.68
8.3.15	0.014	0.004	18.63
8.3.14	0.004	0.014	16.65
8.3.13	0.013	0.007	18.21
8.3.12	0.006	0.003	19.15
8.3.11	0.000	0.009	20.94
8.3.10	0.004	0.011	18.24
8.3.9	0.017	0.000	26.77
8.3.8	0.006	0.003	17.97
8.3.7	0.014	0.007	16.75
8.3.6	0.011	0.011	18.44
8.3.5	0.012	0.003	18.66
8.3.4	0.003	0.010	20.13
8.3.3	0.006	0.009	20.17
8.3.2	0.000	0.008	24.18
8.3.1	0.005	0.002	24.66
8.3.0	0.013	0.007	28.09
8.2.29	0.008	0.010	22.23
8.2.28	0.005	0.003	18.70
8.2.27	0.011	0.004	18.73
8.2.26	0.000	0.009	18.34
8.2.25	0.011	0.007	18.68
8.2.24	0.007	0.003	18.76
8.2.23	0.007	0.003	22.58
8.2.22	0.008	0.000	24.06
8.2.21	0.008	0.000	26.77
8.2.20	0.000	0.010	16.75
8.2.19	0.012	0.006	16.88
8.2.18	0.007	0.014	18.55
8.2.17	0.014	0.007	19.02
8.2.16	0.010	0.003	22.96
8.2.15	0.004	0.004	25.66
8.2.14	0.008	0.000	24.66
8.2.13	0.015	0.003	28.09
8.2.12	0.007	0.011	28.09
8.2.11	0.012	0.006	28.09
8.2.10	0.010	0.010	28.09
8.2.9	0.010	0.010	28.09
8.2.8	0.003	0.017	28.09
8.2.7	0.012	0.008	28.09
8.2.6	0.007	0.014	28.09
8.2.5	0.011	0.008	28.09
8.2.4	0.019	0.003	28.09
8.2.3	0.017	0.000	28.09
8.2.2	0.013	0.007	28.09
8.2.1	0.004	0.012	28.09
8.2.0	0.004	0.012	28.09
8.1.33	0.012	0.007	22.00
8.1.32	0.012	0.008	16.53
8.1.31	0.009	0.009	18.43
8.1.30	0.013	0.006	17.03
8.1.29	0.011	0.000	30.84
8.1.28	0.012	0.006	25.92
8.1.27	0.009	0.006	20.76
8.1.26	0.017	0.003	28.09
8.1.25	0.017	0.003	28.09
8.1.24	0.006	0.012	28.09
8.1.23	0.010	0.013	28.09
8.1.22	0.007	0.002	28.09
8.1.21	0.009	0.004	28.09
8.1.20	0.006	0.003	28.09
8.1.19	0.013	0.006	28.09
8.1.18	0.013	0.006	28.09
8.1.17	0.010	0.010	28.09
8.1.16	0.009	0.006	28.09
8.1.15	0.003	0.006	28.09
8.1.14	0.009	0.000	28.09
8.1.13	0.009	0.006	28.09
8.1.12	0.003	0.006	28.09
8.1.11	0.006	0.006	28.09
8.1.10	0.011	0.000	28.09
8.1.9	0.006	0.003	28.09
8.1.8	0.004	0.004	28.09
8.1.7	0.008	0.008	28.09
8.1.6	0.017	0.003	28.09
8.1.5	0.003	0.006	28.09
8.1.4	0.006	0.003	28.09
8.1.3	0.011	0.007	28.09
8.1.2	0.003	0.006	28.09
8.1.1	0.004	0.004	28.09
8.1.0	0.007	0.010	28.09

preferences:dark modelive previewkey bindings