What is a good way to store all the comments for many posts on a web server?

Question

With my current system I am storing posts in a database, each post has its own xml file that stores comments. this works well for now but it feels disorganised and inefficient. Can anyone think of something better? storing them in the database seems like it would have too many entries without a good index

Answer 1

specifiy a comments table with id and post_id column and user_id to specifiy the owner and for which post he wrote the comment. And you may add also a filter for bad words as f***