benchmark_connect-to-pgsql.php

<?php

const LOOP = 50;

$mesuare = function (string $title, callable $func): void {
    printf("<h2>%s</h2>", htmlspecialchars($title));
    for ($i = 1; $i <= LOOP; $i++) {
        $start = microtime(true);
        $time = $func() - $start;

        $mark = $time > 5.0 ? ' <==' : '';
        printf('case%02d: %f%s<br>', $i, $time, $mark);
        flush();

        usleep(1000);
    }
};

$mesuare(
    'pg_connect',
    function (): float {
        $conn = pg_connect('host=db dbname=app user=app password=pass');
        $time = microtime(true);
        pg_close($conn);

        return $time;
    }
);
$mesuare(
    'PDO',
    function (): float {
        $pdo = new PDO('pgsql:host=db;dbname=app', 'app', 'pass');
        $time = microtime(true);
        $pdo = null;

        return $time;
    }
);