YAFLogo

minhsangd
  • minhsangd
  • 53.6% (Neutral)
  • YAF Forumling Topic Starter
14 years ago
i dont know why my database is too large. I had 5000 Record in yaf_Message Table and 5000 record in yaf_Topic table, the Database size is 140 MB+, but my friend used vbb source and had 13.000 record thread and 13.000 record message but the size of his database is 200MB+

is this a problem or bugs?

P/S: i wrote a page to leech thread or message from the other forum and website to my databse, i used Stored Proceduce (topic_save)to post new topic and message....

so is that reason why is database is too large? 🤬

Sponsor
squirrel
14 years ago

i dont know why my database is too large. I had 5000 Record in yaf_Message Table and 5000 record in yaf_Topic table, the Database size is 140 MB+, but my friend used vbb source and had 13.000 record thread and 13.000 record message but the size of his database is 200MB+

is this a problem or bugs?

P/S: i wrote a page to leech thread or message from the other forum and website to my databse, i used Stored Proceduce (topic_save)to post new topic and message....

so is that reason why is database is too large? 🤬

Originally Posted by: minhsangd 

You need to look into SQL database maintenance, such as backup. Depending on the recovery model of your database, your logfiles will grow, causing higher database size. We have 185,502 posts in 19,058 topics in 13 forums with a member count of 1800+ and our DB uses about 250mb. But I have not run backup and shrink lately which cleans up 'unused space' and 'log space'...


If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend 
minhsangd
  • minhsangd
  • 53.6% (Neutral)
  • YAF Forumling Topic Starter
14 years ago
i run YAF in Local.... i looked into Message Table, and the size is 125MB+...... :-?
minhsangd
  • minhsangd
  • 53.6% (Neutral)
  • YAF Forumling Topic Starter
14 years ago
and now with 8000 Message and 8000 Topic.... the size of Database is 200MB @@.... the problem is Yaf_Message Table is 195MB+.... i looked into and there is no point >"<

P/S: i'm running YAF in Local, Visual Studio 2010 , MsSQL 2005

squirrel
14 years ago

and now with 8000 Message and 8000 Topic.... the size of Database is 200MB @@.... the problem is Yaf_Message Table is 195MB+.... i looked into and there is no point >"<

P/S: i'm running YAF in Local, Visual Studio 2010 , MsSQL 2005

Originally Posted by: minhsangd 

Again, you need to check your database recovery model. SQL will count the transaction logs as part of a table size. If your table is tracking lots of transactions (IE you have imported a large amount of topics), your transaction log will be quite large, this consuming lots of space.

You should also try running a FULL backup of the database, then run a SHRINK on the database once the backup has completed, then check your table sizes again.

When I imported the above forum into YAF from Snitz, I had a database that was over 450 megs after the import scripts were run. I then dropped the Snitz Tables, ran a backup, then a shrink, and we were down to 190mb.


If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend 
Dimi
  • Dimi
  • 100% (Exalted)
  • YAF All-the-Time
14 years ago

[quote=minhsangd;46160]and now with 8000 Message and 8000 Topic.... the size of Database is 200MB @@....

Again, you need to check your database recovery model. SQL will count the transaction logs as part of a table size. If your table is tracking lots of transactions (IE you have imported a large amount of topics), your transaction log will be quite large, this consuming lots of space.

You should also try running a FULL backup of the database, then run a SHRINK on the database once the backup has completed, then check your table sizes again.

When I imported the above forum into YAF from Snitz, I had a database that was over 450 megs after the import scripts were run. I then dropped the Snitz Tables, ran a backup, then a shrink, and we were down to 190mb.

Originally Posted by: squirrel 

Absolutely right! The recovery mode is critical to the database size. We do NOT have a full recovery mode enabled on our working database. I'm not talking about YAF related database, it's absolutely different one related to medicine. It's MS SQL Server 2008 and the current database size is Half-a-Terabyte.

If it's not a problem with server space or Internet Provider limitation, I would not bother with the database size. 150 or 200 MBytes is not critical and it's not a huge difference anyway!

Btw, people, are you saving the attachments inside the database? I initially switched to files and I'm getting a huge sub-directory with all the attachments. There is a little trouble to backup these files, but that's all. it's much harder to keep the huge database sharp.

There is a question for the developers! If someone swtiches from using database table for attachments to separate files, what's gonna happen? Will he lose all the files, or the forum will combine both showing the attachments corectly and all the next attachments will be saved according to the selected option?


Dimi

UserPostedImage