Should the database connection be opened once per request or multiple times?

Opening a database connection multiple times per request can lead to performance issues and unnecessary resource consumption. It is recommended to open the database connection once per request and reuse it throughout the request to improve efficiency and reduce overhead. 

// Open a database connection
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

Keywords

PHP database connection performance optimization singleton pattern

Related Questions