Re: [PHP-DB] MySQL connection

Ah, thanks for the reply Joshua.

Duly noted. So when is it bad to make multiple open and close =
connections then?
I am guessing that could have some impact with lots of users too. Yes?

If the website in question does not have a lot of users (less than =
1,000), is this still a bad call to keep an open connection?
If so, should I be closing the connection after each page load that has =
multiple calls on the database?
Or after each call to the database?=20

I am wanting to make sure I am not doing something bad or dangerous when =
holding these sessions open.
If it is a matter of taste, I'll leave it, but if it is a matter of best =
practices to open and close, I will change the method I am using.

Again, TIA!

Best,

Karl DeSaulniers
Design Drumm
http://designdrumm.com




> On Mar 5, 2017, at 6:19 PM, Arneson, Joshua <[email protected]> =
wrote:
>=20
> Right off the bat, you need to consider concurrency issues. Depending =
on the size of your user base and level of activity this could become a =
major issue. In the end, why hold an open connection for 15 minutes just =
to process 20-30 transactions that take 20-30ms each? Just better (under =
most circumstances) to open the connection, process your transaction , =
then close the connection.=20
>=20
> Respectfully,
>=20
> Joshua D. Arneson
> Data Manager, Mount Sinai NIH Brain & Tissue Repository (NBTR)
> 130 W Kingsbridge Rd, Rm 5F-04
> Bronx, NY 10468
> Email: [email protected]
> Office: 718-584-9000 ext 6094
> Mobile: 347-915-8911
> Fax: 718-741-4746
>=20
>> On Mar 5, 2017, at 6:54 PM, Karl DeSaulniers <[email protected]> =
wrote:
>>=20
>> Hello everyone,
>> Long time. Hope all are well.
>>=20
>> Quick question. How should MySQL connections be treated?
>> Is it ok to leave them open or is it better to close them after =
transactions?
>> I have a website that uses sessions and was wondering if there was =
any situations where I should be closing the connection.
>> Either for performance reasons or security or best practices.=20
>>=20
>> Just wondering your professional.
>>=20
>> TIA
>>=20
>> Best,
>>=20
>> Karl DeSaulniers
>> Design Drumm
>> =
https://urldefense.proofpoint.com/v2/url?u=3Dhttp-3A__designdrumm.com&d=3D=
DwIFAg&c=3DshNJtf5dKgNcPZ6Yh64b-A&r=3DHSbgyt8GFSyWQ53Nxworjip-dgIKnMlPBkQ0=
VGj7tYk&m=3D09oI7Bn2rpePGXSl8CmHMTUqhm3Rjh676OnMYed0L_4&s=3DJBoK9bslzQegAx=
QDG_NbsuvcCBLw5_LIQkjMpEj4kE8&e=3D =
<https://urldefense.proofpoint.com/v2/url?u=3Dhttp-3A__designdrumm.com_&d=3D=
DwIFAg&c=3DshNJtf5dKgNcPZ6Yh64b-A&r=3DHSbgyt8GFSyWQ53Nxworjip-dgIKnMlPBkQ0=
VGj7tYk&m=3D09oI7Bn2rpePGXSl8CmHMTUqhm3Rjh676OnMYed0L_4&s=3Du_sgRk_DWdl5PZ=
ZinSHklw5DuV7oz5cv7MWZCJDsJzA&e=3D >
>>=20
>>=20
>>=20
>>=20
>=20
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php