开发者

mysql structuring comment system, will it take forever?

开发者 https://www.devze.com 2023-03-15 01:59 出处:网络
I\'m wondering if I structure my comment system with just one table where I have all my comments and userid will be good?

I'm wondering if I structure my comment system with just one table where I have all my comments and userid will be good?

I want to know if this system will take forever for mysql to get the results if I have lots of comments, and mysql is trying to query only specific userid with the comments associated with it. If anyone have any suggestions, I'd like to hear 开发者_StackOverflow社区it. Thanks!


It shouldn't be slow. Make sure that you have an index for the user id and the thread id.

0

精彩评论

暂无评论...
验证码 换一张
取 消