I'm going to make an asp.net site backed with a database.
Now I'm having a bit of doubts about the design I've made and some questions.
Here's the design for now:
http://simonverhoeven.be/images/database%20design.jpg
An arrow indicates a relation.
If I write my own login system and I don't use the default asp.net login control then I can merge the users and userinfo table.
It is also possible to merge the articles and articleContent tables.
Now the reason I've split the articles and articleContent is that I'm planning on doing the following:
-use the first table to create a page with a short summary and the second one will contain the html page in the content field. (I'll be using master pages)
Now my doubts:
-will splitting these decrease loading times or am I way off?
-will the increased database usage by the content field offset the gain of having less pages?
-and I'm thinking about tracking the post count/article. Now when does using an extra field outperform a join with a count function. Or should I just choose one of the both and stick with it?
I would also like to track the comment count of a user, here I have the same doubts for posts/user.
Thank you in advance.