How to set up tables. Dynamic content?
My question involves a scenario, so I'll use twitter as the example. We have a table with user id, pass, etc. Now, we have a table with all tweets? Does each user have their own table with tweets or, when a page loads, does the server search through EVERY tweet from EVERY user and match user ids? I'm just confused how else you would find a specific user's tweets than to search through every tweet. Hope this makes sense, currently learning the basics but stuck on this idea.