Storing a music playlist, best approach?
I would approach it with this structure:



This way you can have a more normalized structure, non-repeating data and simple tables.

In this method you would also be using WHERE PlaylistID=[bobs playlist id] instead.

With this structure's simplicity, you wont have to worry about any size issues for a long time. This structure will quickly handle millions of records. If you get bigger than that you can look into partitioning; that's not necessary for now.