mysql, help problem

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
ppc
Forum Newbie
Posts: 14
Joined: Sat May 27, 2006 9:59 pm

mysql, help problem

Post 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?
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
Post Reply