Consider a web application with 100,000 users. Each user can create blog posts. Assume each user has 100 entries.
Would it be appropriate to store all the users in one table, with another table to store the entries made by each user?
Is this a bad design? What would be an efficient way to store all the information to facilitate quick access of the information?