Comments System (Programming)

I am not into coding a comments system but i want to know how these work.

Here is my idea of how these work :- You basically create a Comments table with has a ID column which contains the Id of the post at which the comment is posted next the actual comment and then some data about the commenting person . To show the comments under a post we query all the rows that have the id of the post .

any more ideas????

--- Updated Post - Automerged ---

If what i think is correct what if the blog becomes super big like lifehacker or gizmodo can the database react fast ??

--- Updated Post - Automerged ---

Bump..........
 
Back
Top