I know that the number of posts will be needed to determine this, but is there a recommended limit of say 200 forums not to go over... Do you have any stats on what some of the larger sites are doing... I went to sony music and see they have 153k registered users and I was trying to figure out the number of posts and it looks like they are using a different table or db for each board.. I tried punching in low post numbers for different boards and kept getting different posts.. Interesting. From the index page, there appear to be over 500k posts. I bumped over to mycoupons.com and they look like they have "Hundreds of Thousands of Happy Members" with about 20k posts on the main index page and the post numbers appear to be up to almost 500k now. Internet movie database doesn't show members, but shows about 120k posts on the main index page and the post numbers appear to be just over 350k now... If my math is right, my coupons gets about 25 replies per post where imd gets about 3, does that sound right.. it's interesting. so much for trying to figure out average replies per post and getting total post numbers..
I'm assuming the last two are using just one database and sony has pretty much tricked out theirs pretty well for either multiple tables or databases for posts (I also noticed fansonly.com doing this with multiple tables or databases as well...
So is there a break point somewhere and do you know if sony and fansonly are using separate tables or separate database for their boards?