Overall capacity of the vBulletin

[Kim]

Hi All

This is my first post on this board.

I have some questions I would like some answers on,thanks.

1. How many members can the board support, does it depends only on the mySQL server/space. We are looking for a board than can handle 50.000-100.000 members ?

2. What is the "industrial strength" compared to UBB. ?

3. How many postings can be made at the same time ?

4. More answers of this kind, would help ?

Kim

[Myrhillion]

flat file vs. sql db should be enough to convince you to not use UBB.

With the amount of members you're talking you really need to look at a database driven solution.

[Martin]

it depends a lot on the concurrent users and your server strength.

if you have 50k to 100k users, you will need a sturdier database than mysql if you're going to have more than a few hundred active at a time.

a sybase back-end is currently in the works and I think that would be more suited to running something with that many members. I have 5k members and rarely fewer than 120 at the site at a time during peak hours. Doing the math, you would have 1-2k on board at a time and I don't know if mySQL can handle it. I think saying it can't is a pretty safe bet.

Now, if you have a smaller membership than that now and are looking at getting that many members, start out with mySQL and as traffic builds, boost up your back-end.

As far as mySQL vs Flat File (or vB vs UBB) when I made the switch I had less than 3k members and it would take upwards of 2 minutes for a post to show up when I had less than 100k posts en todo.
I just broke 250k (since July) posts today and it still takes less than 30 seconds to compelte a post running PHP as CGI on an NT server. The results are much faster running *nix/Apache.

[Thud]

corvetteforum.com just attempted a conversion from UBB to vB earlier today.

It has 15,000 registered users, and probably several hundred viewing at once (just guessing). Currently the admins are manually archiving old posts after a week which has kept it pretty speedy with UBB but there's no searching.

Anyway, with vB, the site ground to a screeching halt very quickly. It was taking several minutes to load a new page, and posting anything was a 10-minute process. Keep in mind this is on a dual P3-650 web server with a dual P3-750 dedicated database server!! Both running FreeBSD I believe.

Long story short, it's back on UBB for now... maybe something wasn't configured properly, I dunno.

[Troy Roberts]

Hi Thud - funny meeting you over here! ;)

fyi - The database server is on Redhat Linux. The rest of the config above is correct.

We believe that we had everything properly setup. All indexes setup. Max connections tweeked, etc...

mysql just couldn't handle it. If we are to move to vb we're going to need a version that supports a more industrial strength database.

[Troy Roberts]

Oh yeah - we hit just under 300 concurrent users when it started to slow down dramatically.

We also have about 100 meg in the database that was brought over from UBB.

[Martin]

as I said in your other topic, it would be helpful to see your mySQL settings.

[werehere]

You could also check out this post which may help you decide hardware! :)


http://vbulletin.com/forum/showthread.php?threadid=5387