> We use PHP. > I´ll try it with mysql_pconnect(); > I´ve already thought about it. > What happens, when we´ve several 1000 Users online. Doesn´t > it open too many connections ? > mysql_connect closes every connection after using. > Does mysql_pconnect() the same ?
I think, it's in the docs...please RTFM: " First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection. Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (mysql_close() will not close links established by mysql_pconnect()). " ( http://www.php.net/manual/en/function.mysql-pconnect.php ) Regards, TomH -- PROSOFT EDV-Loesungen GmbH & Co. KG http://www.proSoft.org St.-Kassians-Platz 6, D-93047 Regensburg [EMAIL PROTECTED] Geschaeftsfuehrer: Axel-Wilhelm Wegmann phone: +49 941 / 78 88 7-121 AG Regensburg HRA 6608 USt.183/68311 cellphone: +49 171 / 40 54 777 -- > -----Original Message----- > From: ESV Media GmbH [mailto:[EMAIL PROTECTED] > Sent: Saturday, January 14, 2006 4:27 PM > To: mysql@lists.mysql.com > Subject: Reload Problem -> "Mass-Reload" crashes DB > > Thanks for your quick reply. > > Thanks a lot for your help > > Marco > > Tom Horstmann wrote: > > Dear Marco, > > i'm not sure, this can be solved by MySQL itself, but if you're e.g. > using php you may try to use mysql_pconnect () instead of > mysql_connect (). Please see > http://www.php.net/manual/en/function.mysql-pconnect.php > and > http://www.php.net/manual/en/function.mysql-connect.php > > In your favourite server-side-language there may be other > functions for persistant database-connections. > > hth, > > TomH > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]