+ 1

How to store comments in a database?

Is using one table for comments for a social network efficient...i mean the server needs to search the whole comments table and find the comments that belong to a certain post in order to render comments on the page. Imagine doing that for millions of users at the same time.

17th Aug 2019, 3:24 PM
omar
omar - avatar
2 Antworten
+ 7
I ain't a DB expert but i think it's pretty straightforward Suppose you have a posts table and a comments table with the following columns: posts(id, user_id, body, create_date, update_date) comments(id, post_id, body, create_date, update_date) Using post_id as a foreign key should be enough => when retrieving a post, you'd also retrieve all comments with the post_id and have them sorted by create_date For efficiency you could index your tables https://www.geeksforgeeks.org/sql-indexes/ also, you might want to use an ORM to help you make the queries
17th Aug 2019, 4:03 PM
Burey
Burey - avatar
+ 1
So indexing is the only way to optimize our DB efficiency...thanks.
17th Aug 2019, 4:50 PM
omar
omar - avatar