Hello,

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 ?

Thanks
Phil