herman_herman
2009-04-28T21:10:37Z
Hi
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
Sponsor
Mek
  •  Mek
  • 100% (Exalted)
  • YAF Developer
2009-04-28T21:56:11Z
Don't forget to take transaction logs into the equation.

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


UserPostedImage 

"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 🙂 )
herman_herman
2009-04-29T02:11:10Z
Hi Mek,
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

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved