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.arne...@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 <k...@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= > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
