Tuesday, December 12, 2006
Space vs Speed
Nowadays space is so plentiful and cheap that you don't really need to worry about space. You can run amok and create the most relational database ever, where every file relates to another. Sweet.
Bandwidth, however, is not yet unlimited, though it soon will be. So your main constraint right now is how long it takes to back your database up over the Internet. If you design your backup system well, the whole architecture can be regenerated from a few core backup data files. Then the issue becomes the processing required to unpack a million-user database. And that's a whole new story.