I have 277 users, 387 topics and 9,888 posts on my forum. And size of base is 7.9 MiB! On my old engnine, its size was nearly two time less, 3.8 MiB.
Here's screenshots:
[IMG]http://www.picamatic.com/show/2008/08/05/01/755127_bigthumb.jpg[/IMG]
[IMG]http://www.picamatic.com/show/2008/08/05/01/755128_bigthumb.jpg[/IMG]
Is current db size normal?
Well something is weird there because the only table we need to look at is posts. Technically the size should be identical if you converted the post content byte-by-byte.
Maybe miniBB was storing as single character ascii and bbPress is storing as double character UTF8? That would explain it. bbPress is exactly double the size because it's using 2-byte encoding of the characters.
I know it's bothersome but 8MB is trivial these days.
In theory you could force bbpress to change character sets to your old type and force phpmyadmin to convert the table. But many things could go very wrong with that.
Another thought might be index size?
If you go into each table it will tell you the data vs index size.
Take a look at the index size for bb_posts vs minibbtable_posts
If you are willing, I am curious to see a screenshot of those two also.
miniBB haven't post index at all 
so it describes everything
[IMG]http://www.picamatic.com/show/2008/08/05/05/756436_bigthumb.jpg[/IMG]
[IMG]http://www.picamatic.com/show/2008/08/05/05/756435_bigthumb.jpg[/IMG]
Yeah it's not a UTF8 problem but an index size issue.
bbPress keeps a bunch of indexes for speed.
miniBB uses almost nothing which would hurt a busy site.
I wonder if that fulltext index is what's so huge.
I'll have to fiddle to find out.
Ah yes a fulltext index is an index of every single word and it's location. It's huge.
If you are REALLY bothered by the size, you could manually delete that fulltext index and hope users don't crash your site by doing alot of raw searches (you can always manually recreate the index later too).
no, 10 MB is nothing but the thing I've worried is probable claim from my hoster about something connected with big loading of mysql 
Indexes will reduce the load, so in theory 10 simultaneous searches of the post text in bbPress will have far less load than 10 on minibb.
RSS feed for this topic
You must log in to post.
