Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:128440
Precedence: list
MIME-Version: 1.0
References: <CANdUeab=pbqnJ45gg0qm8gZV_dWOpjexLq0kjzu9QfcPd8VA9Q@mail.gmail.com>
 <CAGBsUrdQC_xN+p1qUupes92czUkVy84OsLk=JY5cgS-sqYB5EQ@mail.gmail.com> <CANdUeaa-iHbSgF3-njm2kMYUo3TE1A4QqKV1y5oJG96gr8fkoQ@mail.gmail.com>
In-Reply-To: <CANdUeaa-iHbSgF3-njm2kMYUo3TE1A4QqKV1y5oJG96gr8fkoQ@mail.gmail.com>
Date: Fri, 8 Aug 2025 19:42:19 +0300
Message-ID: <CAGBsUresr_WzMfMe0osFdzyXzDv3kMirEOtBJWjF5X3GT9p=8A@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="000000000000962d7c063bdd42ab"
From: tekiela246@gmail.com (Kamil Tekiela)

--000000000000962d7c063bdd42ab
Content-Type: text/plain; charset="UTF-8"

On Fri 8 Aug 2025, 19:32 Robert Wolf, <rposky@gmail.com> wrote:

> Persistent connection helps avoid the overhead involved in creating and
>> authorizing a new connection on the server.
>>
>
> That only applies if you are creating multiple PDO objects and expecting
> re-use of the kept-alive underlying connection, correct?
>
> If persistent connections were removed, it is true that any users
> utilizing PDO in this ad-hoc fashion and expecting connection keepalive
> would be impacted. Granted, that potential impact may not be tenable, but
> the workaround would seem rather straightforward to communicate to users
> and to implement - that workaround being for the user to introduce a PDO
> singleton to hold the object reference as long as you wish the connection
> to live for.
>


No, They are reusable across different http requests. There's no point in
reusing them in the same request.

On the first access to the website a new connection is established. On the
second access the same connection is reused provided the first request is
done with it. This way consecutive requests to the website do not need to
open a new costly connection.

>

--000000000000962d7c063bdd42ab
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div><br><br><div class=3D"gmail_quote gmail_quote_contai=
ner"><div dir=3D"ltr" class=3D"gmail_attr">On Fri 8 Aug 2025, 19:32 Robert =
Wolf, &lt;<a href=3D"mailto:rposky@gmail.com">rposky@gmail.com</a>&gt; wrot=
e:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;bo=
rder-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr=
"><span style=3D"color:rgb(80,0,80)"><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid=
;border-left-color:rgb(204,204,204);padding-left:1ex">Persistent connection=
 helps avoid the overhead involved in creating and authorizing a new connec=
tion on the server.<br></blockquote><div><br></div></span><div>That only ap=
plies if you are creating multiple PDO objects and expecting re-use of the =
kept-alive underlying connection, correct?</div><div><br></div><div>If pers=
istent connections were removed, it is true that any users utilizing PDO in=
 this ad-hoc fashion and expecting connection keepalive would be impacted. =
Granted, that potential impact may not be tenable, but the workaround would=
 seem rather straightforward to communicate to users and to implement - tha=
t workaround being for the user to introduce a PDO singleton to hold the ob=
ject reference as long as you wish the connection to live for.</div></div><=
/div></blockquote></div></div><div dir=3D"auto"><br></div><div dir=3D"auto"=
><br></div><div dir=3D"auto">No,=C2=A0They are reusable across different ht=
tp requests. There&#39;s no point in reusing them in the same request.=C2=
=A0</div><div dir=3D"auto"><br></div><div dir=3D"auto">On the first access =
to the website a new connection is established. On the second access the sa=
me connection is reused provided the first request is done with it. This wa=
y consecutive requests to the website do not need to open a new costly conn=
ection.=C2=A0</div><div dir=3D"auto"><div class=3D"gmail_quote gmail_quote_=
container"><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;bor=
der-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div class=3D"gm=
ail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.=
8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204=
,204,204);padding-left:1ex"><div dir=3D"auto"><div dir=3D"auto"><div class=
=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px =
0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:r=
gb(204,204,204);padding-left:1ex">
</blockquote></div></div></div>
</blockquote></div></div>
</blockquote></div></div></div>

--000000000000962d7c063bdd42ab--