CODEWITHSUNDEEP
mysqldata-structuresstructure
hellomello
hellomello

Reputation: 8587

mysql structuring comment system, will it take forever?

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 it. Thanks!

Upvotes: 0

Views: 69

Answers (1)

jncraton
jncraton

Reputation: 9132

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

Upvotes: 1

Related Questions