I dont beleive my Vbulletin database will get as big as your database of 400MB as I use a file system and don't store "Everything" such as attachments and such in the database, Im still thinking that a seperate database for each program is better than cramming them all into one database to make working with the site easier. Am I thinking the right thing here?
I have heard in the past that things perform better when they are all in one database on smaller sites, but slower on larger sites, but im looking at this from an admin's point of view having to do restores and website moves to another server or domain name (if it should ever have to be done), in otherwords what makes things easier on me, especially if the performance gain is very minimal between the two ways of doing things.
My site won't have lots of hits or traffic compared to some of these other sites out there, but I will be running three programs, possibly four that require databases, but for sure i'll be running the following.
Vbulletin, Photo Post Pro, Photo Post Classifieds, Flash Chat.
I'm just wanting to do this right the first time, That's the reasoning behind all the questions and doubt's and confusion.