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?
mysql, help problem
Moderator: General Moderators
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
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
Mac