Thursday, 15 January 2015

php - How should a Facebook-Timeline system look on the database? -


How do I store users "mail"? So that I can get them effectively from DB and then request a specific users' page, then they should be processed to display them in chronological order?

Do I store all the posts from all users in the same table in a similar way: 

  Post ID | Poster id | Post content | Post Wall For This User | Post timestamp   
 Then when a user opens the user page, then I get all the lines where  is posted for this user Wall = UserFoo ?  
 Do the above mentioned sample make a huge amount of tables? Layouts that you consider to be appropriate are 5 columns (four  INT  and one   
 
 TEXT ), is not exactly "heavy" table.  
 If you have appropriate indexes,  
 for your target query (terms displayed on the current user's wall, from time to time), the best index might be  (Post Wall, Post Timestamp for this user)  (a two-column index).   

 








Posted by



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)