Page 1 of 1

mysql, help problem

Posted: Sun Jun 11, 2006 3:03 pm
by ppc
i have UCCASS (bigredspark.com/survey.html) and it is survey software, i might get alot of hits on the site, i was told that theres a maximum connection of 100 to a swl database, how would i avoid this maximum connection, how do big websites like this one im sure running off a sql database have more than 100 sql connections at once?

I was told that theres a way to close the connection immediatly after the script gets the info, can someone tell me what a scipt closing the connection looks like?

Posted: Mon Jun 12, 2006 3:11 am
by twigletmac
Connection limits can be set on the server so you'll need to talk to your host to see what yours is. Not using persistant connections can help if you've got a low limit. You can close a (non-persistant) MySQL connection using mysql_close() once you're done with it.

Mac