<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">When running the variant effect predictor on a local database, I see that it establishes around 20,000 connections to the SQL server. Running multiple instances simultaneously will overwhelm the server causing a can’t-connect exception.<div><br></div><div>If I comment out this line, there are only 2 conections</div><div><div><span class="Apple-tab-span" style="white-space:pre"> </span>#$reg->set_disconnect_when_inactive();</div><div><br></div><div>I understand the purpose of that setting, but I wonder if the disconnects are not actually taking place, yet the program establishes a new connection for each query.</div><div>
<span class="Apple-style-span" style="font-size: 12px; font-family: Helvetica; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'Lucida Grande'; font-size: 10px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><p class="MsoNormal"><font class="Apple-style-span" face="'Devanagari MT'" size="7"><span class="Apple-style-span" style="font-size: 27px; "><font class="Apple-style-span" face="'Lucida Grande'" size="3"><span class="Apple-style-span" style="font-size: 12px; "><br class="Apple-interchange-newline"></span></font><font class="Apple-style-span" size="5"><span class="Apple-style-span" style="font-size: 18px; ">ॐ</span></font></span></font></p></span><p></p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 6px; margin-left: 0px; line-height: 19px; font: normal normal normal 16px/normal Helvetica; "><span class="Apple-style-span" style="font-family: 'Lucida Grande'; font-size: 10px; ">Michael Yourshaw</span></p><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 10px/normal 'Lucida Grande'; "><span style="letter-spacing: 0px; ">UCLA Geffen School of Medicine</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 10px/normal 'Lucida Grande'; "><span style="letter-spacing: 0px; ">Department of Human Genetics, Nelson Lab</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 10px/normal 'Lucida Grande'; "><span style="letter-spacing: 0px; ">695 Charles E Young Drive S</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 10px/normal 'Lucida Grande'; "><span style="letter-spacing: 0px; ">Gonda 5554</span></div><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 3px; margin-left: 0px; font: normal normal normal 10px/normal 'Lucida Grande'; "><span style="letter-spacing: 0px; ">Los Angeles CA 90095-8348 USA</span></p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 3px; margin-left: 0px; font: normal normal normal 10px/normal 'Lucida Grande'; color: rgb(0, 0, 153); "><span style="text-decoration: underline; letter-spacing: 0px; "><a href="mailto:myourshaw@ucla.edu">myourshaw@ucla.edu</a></span></p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 6px; margin-left: 0px; font: normal normal normal 10px/normal 'Lucida Grande'; "><span style="letter-spacing: 0px; ">970.691.8299</span></p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 6px; margin-left: 0px; font: normal normal normal 9px/normal 'Lucida Grande'; "><span style="letter-spacing: 0px; ">This message is intended only for the use of the addressee and may contain information that is PRIVILEGED and CONFIDENTIAL, and/or may contain ATTORNEY WORK PRODUCT. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.</span></p><div><font class="Apple-style-span" size="1"><span class="Apple-style-span" style="font-size: 9px; "><br></span></font></div></span><br class="Apple-interchange-newline"><br class="Apple-interchange-newline"></span></div></span>
</div>
<br></div></body></html>