Reset Password · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

Posted by: herman_herman - Tuesday, 28 April 2009 23:10:37
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

Posted by: herman_herman - Tuesday, 28 April 2009 23:10:37

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

Posted by: Mek - Tuesday, 28 April 2009 23:56:11
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

Posted by: herman_herman - Wednesday, 29 April 2009 04:11:10
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: [code]USE MYYAFDB; ALTER DATABASE MYYAFDB SET RECOVERY SIMPLE; DBCC SHRINKFILE (MYYAFDB _Log, 5); ALTER DATABASE MYYAFDB SET RECOVERY FULL;[/code] But came up with: [code]Statement not allowed within multi-statement transaction. Cannot perform a ShrinkFile operation inside a user transaction. Terminate the transaction and reissue the statement.[/code] 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

Posted by: herman_herman - Wednesday, 29 April 2009 04:11:10

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: [code]USE MYYAFDB; ALTER DATABASE MYYAFDB SET RECOVERY SIMPLE; DBCC SHRINKFILE (MYYAFDB _Log, 5); ALTER DATABASE MYYAFDB SET RECOVERY FULL;[/code] But came up with: [code]Statement not allowed within multi-statement transaction. Cannot perform a ShrinkFile operation inside a user transaction. Terminate the transaction and reissue the statement.[/code] 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

Important Information: