Alright, so I am embarking on a fairly large project that is complete with user profiles. My question is, what's the fastest, most efficient way to store user meta like books, movies, etc.
I was planning:
metaid | userid | firstname | lastname | movies | books | biography | favfood
Now those aren't necessarily my categories, but would that be efficient? One row per user containing all of his/her data?
OR should I do it the Wordpress way of
metaid | userid | meta_key | meta_value 1 | 34 | movies | The Godfather, Sleeper, Ironman
So each user could have potentially many rows in a database.
So basically is it more efficient to have user data on one row and multiple columns or on many rows and few columns? or does it not matter?