Just curious to know why there are so much differences in database size in different forum software?

For example a fresh installation of YAF under SQL2000 creates a 6 MB database while this is just 60 KB for a forum like SMF (SimpleMachines) or 400 KB for PHPBB.

I would also be grateful if YAF users post the size of their db and number of the posts they have in their own forums just for a comparison.

Thanks

My 1.918 install is standing at 81 mb:

number of posts: 19,263 Posts per day: 14.25

Number of topics: 2,420 Topics per day: 1.79

Number of users: 492 Users per day: 0.36

Board started: 15/08/2005 (1,352 days ago) Size of database: 81 MB

"It's a case of RTFM.. the only problem being we don't have a manual!"

When I post FP:Mek in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting. (Yes I stole this off Ederon 🙂 )

Thanks for reply.

Interesting…I was thinking of something much smaller than that! 80mb for 20000 post and 400 users is a bit large I guess. Do you save files to the db too?

I guess I should give more $ :roll: to my host. I also should pay 40$ for each 50MB SQL2000 and 60$ for SQL2005! :cheesy:

And about transaction logs, does MySQL have transaction log too?

I tried to shrink the transaction via built-in SQL Query in YAF via the following command:

USE MYYAFDB;

ALTER DATABASE MYYAFDB
SET RECOVERY SIMPLE;

DBCC SHRINKFILE (MYYAFDB _Log, 5);

ALTER DATABASE MYYAFDB
SET RECOVERY FULL;

But came up with:

Statement not allowed within multi-statement transaction. Cannot perform a ShrinkFile operation inside a user transaction. Terminate the transaction and reissue the statement.

I took a brief look at MSDN and I didn't find any solution. The command is executed well in Query Analyzer of SQL Manager but not within Application. Any idea?

What about adding a DB optimization section to YAF (Defrag, Shrink, Backup and..)?

Regards