Database Connections

Hello,

I am hosted with site5 and i am limited to "All MySQL users are
restricted to 15 concurrent connections.". I am about to host a forum
with about 200 members, Does this mean only 15 users will be able to
view my forum's threads at one given time?

Cheers,
Marc

Oops.. Forgot this.

Link to usage Policies: http://wiki.site5.com/Resource_Usage_Policies

I'm pretty sure you can,
mysql queries take seconds.

You won't have a problem, I wouldn't imagine. Each member won't have an individual connection to the db, it doesn't quite work like that. I would have though 15 concurrent connections would be enough for most online apps.

Pete.

Yea I eman - for a company the isze of Site5 it would be a ridiculous limit to put on.

Even if you weren't hosting a forum - only being allowed 15 people to view your php based portfoilio or blog at a time would be stupid and they would never sell a hosting package with that limitation I don't think.

I think that you would have to be connecting to different databases at the same time to even use more than one of your allotted connections. I really wouldn't worry about it unless you're thinking of implementing a major online app and then you should be on a dedi server anyway so no problems.

Pete.

with this:
No single database may exceed 2 GB disk space.

I don't think they would only let 15 people use it at a time if they give you a ridiculous amount for a database

Given that a server could easily be hosting several hundred sites at least, limiting connections makes some sense. This may or may not be an issue for you, but you might get away with it. Unless there is a problem with your forum application, most queries should be very quick, although some forum software makes make quite a few queries for each page request, which does increase the probability of exceeding the limit. Searches are likely to be the longest running queries, and this could be where any problem shows up.

However you say that the forum has 200 members, and whilst that may grow, only a fraction will be active at any one time. If it were an average of 200 active users then this would be a different matter.

Ok, ill put it up and give it a try, and if that fails i will more than likely be looking for a VPS. Anyone reccommend? The cheaper the better

If you need recommendations for VPS services, check
http://www.a2hosting.com/vps_hosting.php
http://www.myriadnetwork.com/services/vds.php

Thanks, keep em' coming!

OK guys, to answer your question about this it is probably stating that only 15 connections at the same time can be made to the database. Seeing as how Microsoft's Access doesn't even allow half that many connections and some extremely large forums run off of an Access database, I doubt you'll have any problems. Just make sure you remember to close your connections to the database in your code. Usual access times are so low you'd probably have to have 1 million people all clicking a button at the same time in order for 15 to query at once anyways. So its highly unlikely. Good programmers will always put in a "could not connect" clause to let their user know they need to try again anyways.

EDIT: Added Database users...

Every database is assigned a "user" who can access this database. It's like loggin in to the database and each user can have 15 concurrent connections. So the above message I entered I am almost 100% sure that is what they are talking about. You can define your user in your control panel with your host and that is the username and password that you use to connect to the database, which everyone will be using the same username to connect to the database as its not something the user enters but is instead coded into the website.

Ok, cheers people.

I probubly should have told you's this earlier, i am using a vBulletin forum.