$pdo = new PDO('mysql:host=db', 'user', 'pass', [ PDO::ATTR_LAZY_CONNECT => true ]); // No connection made yet! $pdo->query("SELECT 1"); // Only now connects
This is critical for frameworks that instantiate many unused services. Tests performed on PHP 8.3, MySQL 8.0, 10k queries: pdo v2.0 extended features
$pdo->enableDebug(function(string $sql, array $params, float $executionTime, ?string $error) if ($executionTime > 100) // milliseconds logger->warning("Slow query: $sql", ['params' => $params, 'time' => $executionTime]); if ($error) logger->error("Query failed: $error", ['sql' => $sql]); ); This extended feature also captures stack traces, making it easier to locate where slow queries originate. PHP 8.1 introduced Fibers, and PDO v2.0 leverages them for non-blocking database calls — a game-changer for high-concurrency applications. $pdo = new PDO('mysql:host=db'