PHP MySql 评论系统
我正在尝试为我的网站构建一个评论系统，评论系统与我们在 Facebook 上看到的非常相似，我正在尝试弄清楚 Facebook 如何如此快速地存储和检索评论，任何人都知道他们正在使用哪种技术，视图、存储过程或者我不知道的东西？
谢谢
I am trying to build a commenting system for my site, commenting system is much similar to what we see on facebook, I am trying to figure out how facebook stores and retrieves comments so fast, anyone have any idea which technique they are using, views, stored procedures or something I am not aware of??
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
他们已经完全定制了他们的数据结构...
在这里找到了其他用户的这些链接...
他们是这样说的：
Facebook 不使用 RDBMS 进行数据管理。
他们使用一种称为 Map/Reduce 的非关系技术，该技术包含在 Hadoop 项目中。他们构建了一个名为 Hive 的项目，用类似 SQL 的语言查询数据。他们还构建了 Cassandra，这是另一种大规模的非关系数据管理技术。
http://20bits.com/articles/data-management-facebook-style/
http://www.facebook.com/note.php?note_id=89508453919
They have completely customized their data structure...
Found these links from another user on here...
Here is what they said:
Facebook doesn't use an RDBMS for their data management.
They use a non-relational technology called Map/Reduce, included in the Hadoop project. They built a project called Hive to query the data with an SQL-like language. They also built Cassandra, another high-scale, non-relational data management technology.
http://20bits.com/articles/data-management-facebook-style/
http://www.facebook.com/note.php?note_id=89508453919
他们做了很多事情！但如果您有一个小网站，他们会做一些事情并且可能会帮助您。
They do a lot of things! But if you have a small site, there are some things they do and may help you.
我猜他们正在将东西存储在数据库中。此外，他们还使用缓存来检索更快的结果。
i am guessing they are storing things in a database. also, they use caching to retrieve faster results.
17% 接受率？你应该改进这一点，以便让人们继续帮助你。无论如何，因为我是个好人，所以我给你答案来帮助你解决你的问题 - 阅读：
Facebook 的新实时消息系统：HBase 将存储超过 1350 亿条消息月份
和
消息底层技术
17% accept rate? you should improve that in order to get people helping you anymore. Anyways, because I am such a good guy, I am giving you the answer to help you with your question - read:
Facebook's New Real-Time Messaging System: HBase To Store 135+ Billion Messages A Month
And
The Underlying Technology of Messages