Forum hosting / DB queries etc

OK, so I'm going to host a vbulletin forum. Of course VB is a very DB intensive program (at least it seems to be to me). I'm hosted on another host right now, and there are just times of the day, that I can almost call that the site just slows to a crawl. If it was at 3am - 5am eastern, no biggie, but it seems to happen at like 8 am.

But I digress..

I know that the shared hosting allows 25 sql connections at once, but that still allows a larger number of folks to use it. Is that 25 connestions per DB or 25 per account? IE: for different add ons for VB if I have different DB's would that allow 25 for each, also spreading it out some.

What are the limits of DB queries? I was installing one addon that uses a zip code file and it exceeded my 50k queries, so I had to wait 15 min or so for it to allow me to use it again, but I couldnt get that autimatically installed.

I guess there is nothing that stinks more then having your users click a link on the forum and it takes over a minute to pull up sometimes.

This new forum I'm going to be running could be having 200 or so users browsing at one time with no problems. IF it goes well, could have more (at that point of course I'd consider either a semi or fully dedicated server if the funding allows ).
in advance for some insight.

[Sam]

Originally Posted by TripMaster

I know that the shared hosting allows 25 sql connections at once, but that still allows a larger number of folks to use it. Is that 25 connestions per DB or 25 per account? IE: for different add ons for VB if I have different DB's would that allow 25 for each, also spreading it out some.

The limit is per MySQL user

What are the limits of DB queries? I was installing one addon that uses a zip code file and it exceeded my 50k queries, so I had to wait 15 min or so for it to allow me to use it again, but I couldnt get that autimatically installed.

Not sure about that limit. Someone else might know

OK, so either a 2nd DB or just a 2nd DB user on the same DB gets the 25 connections? Cool..

[Sam]

Originally Posted by TripMaster

OK, so either a 2nd DB or just a 2nd DB user on the same DB gets the 25 connections? Cool..

Yes...

[Goddess Dix]

Originally Posted by TripMaster

This new forum I'm going to be running could be having 200 or so users browsing at one time with no problems. IF it goes well, could have more (at that point of course I'd consider either a semi or fully dedicated server if the funding allows ).
in advance for some insight.

200 concurrent users is nothing on a vb forum and if you're having slowdowns at any host for this (not to mention time-consistent slowdowns), it's almost certainly the hacks you've installed and has nothing whatsoever to do with your hosting.

if you add the debug command in your config file, you can see what queries are running on your install and get some idea of what might be slowing you down. add this line to your config.php in your vb include folder.

$config['Misc']['debug'] = true;

your forum folks will see it, so it's up to you if you want to go offline to do it. just remove it when you find out what you need to know. shoutboxes, if you have them, are pretty notorius for server load. you sound like a hack-happy kind of guy, so you might end up having to give up some of the more extraneous ones if you want good performance.

anywho, good luck. peace out.