| Author |
 Topic  |
|
|
JJenson
Advanced Member
USA
2121 Posts |
 Posted - 27 July 2007 : 17:49:10
|
Rui just read another post of using MS SQL if more than 50 simultanious users on. IS this the limit of MySQL? This new site I am doing is in MySQL and has the possibility of having alot more than that. Should I be worried now?
THanks
Jeff |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 July 2007 : 19:32:54
|
| I know from previous experiences that some GoDaddy accounts allowed only up to 50 simultaneous connections to the MySQL server. It's a godaddy issue and not with all the accounts. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 28 July 2007 : 01:47:25
|
| Oh ok. So the site I am starting now it shouldn't be a big problem? I am just worried for the futur cause I believe this has a definant possibility to go well over that. |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 28 July 2007 : 12:06:50
|
I was with GD and less than 6 months into my forum it started going down about every 5-7 days.
After about the 4th time, support told me I must upgrade the account from the economy to the mid-grade hosting package due to open connections or they would not provide support for me any more.
I did, and continued to go down periodically, although not as often. They told me my software was not closing connections. Funny, I moved to another host and magically there was nothing wrong with my connections anymore. |
Switch the order of your title tags |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 28 July 2007 : 12:40:22
|
quote:
They told me my software was not closing connections
which in itself is just rubbbish, ASP closes connections automatically when a page has finished renderring even if you don't explicitly close them (which Snitz does anyway). If connections are being left open it is more likely a result of the webserver crapping out before the page has rendered and is a symptom of over subscribed web servers. |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 28 July 2007 : 12:50:44
|
| Yeah I was with them in the very beggining and have since moved on and have had a great host now. I just saw the post and mainly wondered if MySQL could handle the load of a big forum. I really don't know the difference between the two minus what I hear is MS SQL is a much better way to go. SO was just concerned for the future lol |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 28 July 2007 : 13:18:59
|
quote:
which in itself is just rubbbish, ASP closes connections automatically when a page has finished renderring even if you don't explicitly close them
They told me it takes 20 minutes for them to close by themselves. They also acted like they were doing me a million dollar favor by giving me my own app pool. I'm guessing that should've never been needed in the first place. I'm so glad I moved.  |
Switch the order of your title tags |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 28 July 2007 : 17:26:28
|
quote:
They told me it takes 20 minutes for them to close by themselves.
simply not true, they are closed automatically when asp finishes processing the page, the 20 mins would relate to the time it takes the connection to time out if it doesn't receieve a response from the database it has nothing whatsoever to do with closing the recordset or the connection object. It is simply good programming practice to close them once they are finished with. |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 28 July 2007 : 17:46:53
|
HuwR, please don't mistake me stating GoDaddy's statements as meaning I don't believe you. I know GD lies. 
|
Switch the order of your title tags |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 28 July 2007 : 17:53:18
|
it's ok, I wasn't  |
|
|
| |
Topic |
|
Topic Locked
