MySQL database - Profil - How to manage it ?

This site is best viewed in a modern browser with JavaScript enabled.

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 :

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

Option 1 will have better database performance. Unless you plan on adding a lot of fields on the fly I would stick with option 1.