Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:128438
Precedence: list
MIME-Version: 1.0
References: <CANdUeab=pbqnJ45gg0qm8gZV_dWOpjexLq0kjzu9QfcPd8VA9Q@mail.gmail.com>
In-Reply-To: <CANdUeab=pbqnJ45gg0qm8gZV_dWOpjexLq0kjzu9QfcPd8VA9Q@mail.gmail.com>
Date: Fri, 8 Aug 2025 17:59:10 +0300
Message-ID: <CAGBsUrdQC_xN+p1qUupes92czUkVy84OsLk=JY5cgS-sqYB5EQ@mail.gmail.com>
Subject: Re: [PHP-DEV] PDO Disconnect and Persistent Connect
To: Robert Wolf <rposky@gmail.com>
Cc: PHP internals <internals@lists.php.net>
Content-Type: multipart/alternative; boundary="000000000000b45a49063bdbd1fa"
From: tekiela246@gmail.com (Kamil Tekiela)

--000000000000b45a49063bdbd1fa
Content-Type: text/plain; charset="UTF-8"

>
> The added complexity of the feature seems to outweigh the benefits, which
> as best I can gather, is primarily to allow for ad-hoc PDO object creation.
> If that is truly all it brings in benefit, this is a use case easily
> supported by the user via singleton.
>

The primary benefit and use case is for slow network connections between
PHP and MySQL. Persistent connection helps avoid the overhead involved in
creating and authorizing a new connection on the server.

The main disadvantage is the confusion it brings to an average user who has
to be aware of many pitfalls that come with reusable connections.

>

--000000000000b45a49063bdbd1fa
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div><div class=3D"gmail_quote gmail_quote_container"><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #=
ccc solid;padding-left:1ex"><div dir=3D"ltr">The added complexity of the fe=
ature seems to outweigh the benefits, which as best I can gather, is primar=
ily to allow for ad-hoc PDO object creation. If that is truly all it brings=
 in benefit, this is a use case easily supported by the user via singleton.=
</div></blockquote></div></div><div dir=3D"auto"><br></div><div dir=3D"auto=
">The primary benefit and use case is for slow network connections between =
PHP and MySQL. Persistent connection helps avoid the overhead involved in c=
reating and authorizing a new connection on the server.=C2=A0</div><div dir=
=3D"auto"><br></div><div dir=3D"auto">The main disadvantage is the confusio=
n it brings to an average user who has to be aware of many pitfalls that co=
me with reusable connections.=C2=A0</div><div dir=3D"auto"><div class=3D"gm=
ail_quote gmail_quote_container"><blockquote class=3D"gmail_quote" style=3D=
"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
</blockquote></div></div></div>

--000000000000b45a49063bdbd1fa--