MySQL database - Profil - How to manage it ?
I will build a script where user whill have a profil.
This profil will have many fields.
I thinks that there is two way to manage it :
- A table profil with many columns (one columns by option)
- A table like wordpress options (a systèm of key - value)
The second option will be more scalable : if i add a profil data, i won't have to add a column ... it will only create a new "key".
But wich solutions seems to be the best solution ?
For table size / code optimisation.
Which one will you choose ?