Database Size

[maxrocket]

What size database would be needed for an average site.

My host service gave me a 100 MB Database. How many posts will this handle?

Huge thanks!

[Yankidank]

Considering the lenth of the articles, the number of users and such my guess would be that you could potentially fit 25,000+ stories (complete guess) without many comments. This is just an estimate I made from looking at my current DB size (1.8 MB) which is currently holding about 400 articles. This database however has some extra size because I'm attempting to integrate phpbb with it.

I assume that we will eventually offer the ability to purge old unpublished articles in an effort to clean up the database, this will greatly increase your mysql lifetime for 100MB of space because queued stories take up the bulk of the space in most situations.

[chuckroast]

yank, my database is bigger than yours... Nootch!

[chuckroast]

ok, funny stuff aside.
I have approx 25 stories per day, I have approx 9,000 visitors per day... A 100 mb database should last you at least a year.

[maxrocket]

Thats great news! Looks like the issue is for me now is getting the stories not the database size!