Re: MySQL connection
| From: | Arneson, Joshua | Date: | Mon, 06 Mar 2017 00:19:55 +0000 |
| Subject: | Re: MySQL connection | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-49169@lists.php.net to get a copy of this message | ||
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.
Respectfully,
Joshua D. Arneson
Data Manager, Mount Sinai NIH Brain & Tissue Repository (NBTR)
130 W Kingsbridge Rd, Rm 5F-04
Bronx, NY 10468
Email: joshua.arneson@mssm.edu
Office: 718-584-9000 ext 6094
Mobile: 347-915-8911
Fax: 718-741-4746
> On Mar 5, 2017, at 6:54 PM, Karl DeSaulniers <karl@designdrumm.com> wrote:
>
> Hello everyone,
> Long time. Hope all are well.
>
> 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.
>
> Just wondering your professional.
>
> TIA
>
> Best,
>
> Karl DeSaulniers
> Design Drumm
>
> https://urldefense.proofpoint.com/v2/url?u=http-3A__designdrumm.com&d=DwIFAg&c=shNJtf5dKgNcPZ6Yh64b-A&r=HSbgyt8GFSyWQ53Nxworjip-dgIKnMlPBkQ0VGj7tYk&m=09oI7Bn2rpePGXSl8CmHMTUqhm3Rjh676OnMYed0L_4&s=JBoK9bslzQegAxQDG_NbsuvcCBLw5_LIQkjMpEj4kE8&e=
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__designdrumm.com_&d=DwIFAg&c=shNJtf5dKgNcPZ6Yh64b-A&r=HSbgyt8GFSyWQ53Nxworjip-dgIKnMlPBkQ0VGj7tYk&m=09oI7Bn2rpePGXSl8CmHMTUqhm3Rjh676OnMYed0L_4&s=u_sgRk_DWdl5PZZinSHklw5DuV7oz5cv7MWZCJDsJzA&e=
> >
>
>
>
>