Best way of doing this (minimum queries / fastest set of queries)
statuses sid - INT(10) - PRIMARY KEY uid - INT(10) - FOREIGN KEY status - TEXT dateline - BIGINT(30) tweetid - VARCHAR(20) ________ status_comments cid - INT(10) - PRIMARY KEY sid - INT(10) - FOREIGN KEY comment - TEXT dateline - BIGINT(30)
The thing is, it's required that the 10 most recent statuses are shown on a page - along with the comments for each status. Obviously, I need to run a query to get the 10 latest statuses. I could then run a query for each of these ten statuses to get their related comments, but that seems like an awfully long-winded way of doing it.
I'm really not the best at SQL, so I was wondering if any gurus here might know of a handy little query I may be able to run?