So I'm wondering what's the best way to create a friend system in a MySQL database performance-wise. So far, I have seen people use one of two options: Spoiler: First Method The first method consists of two columns in the database: The first column is obviously the UUID. The second column is a long TEXT datatype that separates all of the player's friends with a character (Like a comma) UUID Friends Player1 Player2,Player3,Player4 Though, I do have a question: Shouldn't this mean that each individual UUID gets their own row? Like this: UUID Friends Player1 Player2,Player3,Player4 Player2 Player1,Player3 Player3 Player1,Player2 Player4 Player1 I'm sure this method requires a lot more storage. Spoiler: Second Method The second method consists of two columns in the database: The first column is surprisingly still the UUID. The second column is a UUID of a player's friend. UUID Friends Player1 Player2 Player1 Player3 Just like the first method, should the table look like the example above? Or like this: UUID Friends Player1 Player2 Player2 Player1 Player1 Player3 Player3 Player1 What's the most efficient way? What are the pros/cons of each method?