l have a thought , but it is an "unrelated" question in this post , sorry again .
l like to ask question here and l love spring forum very much -- simply because a lot of helpful people here.
l don't know why the forum being changed to vBulletin , the forum's performance seem to be one of the problem , yes , l notice too , the old forum was a little bit slow this few months , l wonder why it getting slow ? so l went to download a phpbb's source code , study how they design the database tables , and l found the database shema (mysql_shema.sql) , here is a code snipplet ,
l was thinking that , what if the phpbb_posts_text tables growth fast in a high volume forum ?
CREATE TABLE phpbb_posts_text (
post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
bbcode_uid char(10) NOT NULL,
PRIMARY KEY (post_id)
if the number of posts growing fast , will this cause the database performance getting slower ? of course , you won't see the problem, this is unnoticeable now, but the fast growing of phpbb_posts_text is a fact . The response time of hibernate forum is consider OK now , but what if 5 or 10 years later ?
Although this is a common database tables design (phpbb) , but l seldom see people discuss the performance impact on a database after 5 or 10 years , l search a lot references .. found no info ..
My question can be is simply restate - can vBulletin satify us after 15 year (or more) ?
l guess there must be a lot DBA expert here ....hahaha
l just checked , spring have 38,727 posts , and hibernate have 98,264 now , this is far from my meaning of high volumn - so let's assume phpbb_posts_text have 10 millions posts.