|
The database contains all the main content on every page, there will only be a few static pages. Almost everything will be user content - articles, diary entries that kind of thing. The biggest tables will be those which contain all the words in all user content and the table which link words to articles.
Every page will be hitting the database, searches will be the biggest hit but it's all pretty efficient (well, I'll found out for sure when it goes live). I use the asp.net cache so it doesn't always do full lookups.
Users can upload images but they are stored on the hard disk not the database.
Sounds like I definitely need a database server but I will monitor it, thanks a lot.
|