Online PHP editor | perf for YpsZN

@ 2023-09-27T16:17:07Z

<?php

class TableController extends Controller
{
    private string $tableName;
    private array $conditions;

    public function __construct()
    {
        parent::__construct();
        $this->tableName = $this->urlInst->params['tableName'] ?? 'book';
    }

    /**
     * 更新
     */
    public function editAction(): void
    {
        $requestData = json_decode(file_get_contents('php://input'), true);

        $params = $this->urlInst->params;
        $tableName = $params['tableName'];

        // 編集できるテーブルか検証
        if (!in_array($tableName, ['book'])) {
            throw new IllegalPostedException("Illegal tableNamee: {$tableName}");
        }

        if ($tableName === 'book') {

            $itemMapperInst = new BookMapper();

            // 個別に編集に $resItems に結果を追加していく
            $resItems = [];
            foreach ($requestData as $info) {
                // 一部が失敗したらその内容を返し処理を続けたいので
                // ループ内で catch し, 再 throw はしない
                try {
                    $itemInst = new Book();
                    $itemInst->fromAry($info);
                    $itemMapperInst->editItem($itemInst);
                    $resItems[] = $itemInst;
                } catch (SkipException $e) {
                    $parsed_exception = $e->getParsedException();
                } catch (IllegalPostedException | \Exception | \Throwable $e) {
                    $parsed_exception = parse_exception($e);
                }

                if (isset($parsed_exception)) {
                    save_exception_log($parsed_exception);
                    $resItems[] = $parsed_exception;
                }
            }

        } else {
            // 他の $tableName の場合の処理
        }

        $this->adminRender([
            'resItems' => $resItems
        ]);
    }

}

class BookMapper extends ItemMapper
{
    /**
     * 更新
     */
    public function editItem(object $bookInst): void
    {
        try {
            $this->pdo->beginTransaction();

            // uniqueId から id を取得
            $rowMapperInst = new CombinedBookRowMapper();
            $combinedBookId = $rowMapperInst->getIdByUniqueId($bookInst->combinedBookUniqueId);
            if (!$combinedBookId) {
                // uniqueId が存在しない場合
                throw new NotFoundException("not found uniqueId: {$bookInst->combinedBookUniqueId}");
            }

            $bookInst->combinedBookId = $rowMapperInst->getIdByUniqueId($bookInst->combinedBookUniqueId);

            // tbl_books テーブルをUPDATE
            $rowMapperInst = new BookRowMapper();
            $rowMapperInst->editByBookInst($bookInst);

            // tbl_combined_book_titles テーブルをUPDATE
            $rowMapperInst = new CombinedBookTitleRowMapper();
            $rowMapperInst->editByBookInst($bookInst);

            $this->pdo->commit();
        } catch (SkipException $e) {
            $this->pdo->rollBack();
            throw new SkipException($e->getParsedException());
        } catch (\Exception $e) {
            $this->pdo->rollBack();
            throw new SkipException(parse_exception($e));
        }
    }
}

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.1	0.009	0.009	16.80
8.5.0	0.011	0.010	20.18
8.4.16	0.010	0.012	23.73
8.4.15	0.002	0.001	14.05
8.4.14	0.012	0.011	17.44
8.4.13	0.012	0.009	17.65
8.4.12	0.008	0.011	19.50
8.4.11	0.011	0.009	24.01
8.4.10	0.014	0.006	17.81
8.4.9	0.009	0.010	20.66
8.4.8	0.013	0.007	18.73
8.4.7	0.011	0.008	18.95
8.4.6	0.008	0.007	21.98
8.4.5	0.009	0.009	20.35
8.4.4	0.011	0.007	18.00
8.4.3	0.012	0.006	20.70
8.4.2	0.017	0.003	17.85
8.4.1	0.003	0.006	19.63
8.3.28	0.013	0.007	18.65
8.3.27	0.012	0.007	16.82
8.3.26	0.003	0.006	16.75
8.3.25	0.003	0.005	16.54
8.3.24	0.013	0.007	16.70
8.3.23	0.011	0.008	16.70
8.3.22	0.013	0.007	18.91
8.3.21	0.014	0.005	16.91
8.3.20	0.014	0.006	16.70
8.3.19	0.005	0.005	17.24
8.3.18	0.010	0.010	18.90
8.3.17	0.011	0.007	20.62
8.3.16	0.007	0.007	17.33
8.3.15	0.017	0.003	17.04
8.3.14	0.004	0.004	16.76
8.3.13	0.004	0.004	16.66
8.3.12	0.003	0.006	18.87
8.3.11	0.004	0.004	20.94
8.3.10	0.007	0.004	24.06
8.3.9	0.003	0.006	26.77
8.3.8	0.006	0.003	16.50
8.3.7	0.007	0.007	16.63
8.3.6	0.007	0.007	18.30
8.3.5	0.006	0.012	16.93
8.3.4	0.014	0.000	23.79
8.3.3	0.004	0.011	19.09
8.3.2	0.008	0.000	24.18
8.3.1	0.004	0.004	24.66
8.3.0	0.000	0.007	26.16
8.2.29	0.008	0.010	16.62
8.2.28	0.009	0.006	18.57
8.2.27	0.009	0.009	18.66
8.2.26	0.006	0.009	16.63
8.2.25	0.006	0.003	16.50
8.2.24	0.011	0.007	16.74
8.2.23	0.015	0.003	22.58
8.2.22	0.005	0.005	37.54
8.2.21	0.004	0.004	26.77
8.2.20	0.003	0.006	17.00
8.2.19	0.007	0.011	16.75
8.2.18	0.007	0.007	16.63
8.2.17	0.006	0.012	18.99
8.2.16	0.011	0.003	22.96
8.2.15	0.000	0.008	25.66
8.2.14	0.004	0.004	24.66
8.2.13	0.004	0.004	26.16
8.2.12	0.008	0.000	20.95
8.2.11	0.005	0.005	22.11
8.2.10	0.031	0.004	18.44
8.2.9	0.024	0.006	18.44
8.2.8	0.031	0.003	18.44
8.2.7	0.025	0.008	18.44
8.2.6	0.027	0.004	18.44
8.2.5	0.029	0.000	18.44
8.2.4	0.021	0.007	18.44
8.2.3	0.027	0.000	18.44
8.2.2	0.024	0.003	18.44
8.2.1	0.021	0.005	18.44
8.2.0	0.027	0.000	18.44
8.1.33	0.012	0.008	16.29
8.1.32	0.006	0.007	16.38
8.1.31	0.009	0.006	16.52
8.1.30	0.007	0.003	18.08
8.1.29	0.004	0.007	18.88
8.1.28	0.014	0.000	25.92
8.1.27	0.008	0.000	24.66
8.1.26	0.007	0.000	26.35
8.1.25	0.004	0.004	28.09
8.1.24	0.006	0.003	22.10
8.1.23	0.031	0.000	18.44
8.1.22	0.020	0.004	18.44
8.1.21	0.018	0.009	18.44
8.1.20	0.024	0.003	18.44
8.1.19	0.026	0.000	18.44
8.1.18	0.026	0.007	18.44
8.1.17	0.027	0.000	18.44
8.1.16	0.020	0.007	18.44
8.1.15	0.019	0.008	18.44
8.1.14	0.024	0.003	18.44
8.1.13	0.022	0.006	18.44
8.1.12	0.021	0.004	18.44
8.1.11	0.016	0.010	18.44
8.1.10	0.025	0.004	18.44
8.1.9	0.020	0.008	18.44
8.1.8	0.018	0.009	18.44
8.1.7	0.022	0.006	18.44
8.1.6	0.026	0.000	18.44
8.1.5	0.016	0.008	18.44
8.1.4	0.021	0.004	18.44
8.1.3	0.025	0.003	18.44
8.1.2	0.020	0.007	18.44
8.1.1	0.025	0.004	18.44
8.1.0	0.028	0.005	18.44
8.0.30	0.018	0.005	18.44
8.0.29	0.020	0.008	18.44
8.0.28	0.023	0.003	18.44
8.0.27	0.018	0.007	18.44
8.0.26	0.020	0.005	18.44
8.0.25	0.024	0.003	18.44
8.0.24	0.027	0.000	18.44
8.0.23	0.020	0.007	18.44
8.0.22	0.024	0.003	18.44
8.0.21	0.018	0.011	18.44
8.0.20	0.027	0.000	18.44
8.0.19	0.016	0.012	18.44
8.0.18	0.022	0.006	18.44
8.0.17	0.023	0.007	18.44
8.0.16	0.022	0.006	18.44
8.0.15	0.020	0.003	18.44
8.0.14	0.015	0.010	18.44
8.0.13	0.020	0.000	18.44
8.0.12	0.019	0.007	18.44
8.0.11	0.029	0.000	18.44
8.0.10	0.022	0.005	18.44
8.0.9	0.019	0.011	18.44
8.0.8	0.022	0.003	18.44
8.0.7	0.019	0.007	18.44
8.0.6	0.020	0.008	18.44
8.0.5	0.015	0.010	18.44
8.0.3	0.021	0.006	18.44
8.0.2	0.021	0.004	18.44
8.0.1	0.022	0.005	18.44

preferences:dark modelive previewkey bindings