Best Solution /more Tables or all in one?/

--0016364167f9fc44c5047b7ed979
Content-Type: text/plain; charset=UTF-8

Hi i am on to create a database with a lot of entries.

each user may have Records like:

data1 (textfield)
data2 (textfield)
data3 (char [300])
..... and more like that

Now I am thinking about what is better

a:
to create for each field an own Table
like: table_user_data1 (records: userid, data1)
table_user_data2 (records: userid, data2)
table_user_data3 (records: userid, data3)

b:
or to make one table with all included
like: Table_userData
records: (Userid, data1,data2,data3)

My thinking is:
When i make solution a)
contra: i would have several Tabels to scan to get all data
pro: there is only data saved in my database that is used

when i do solution b)
contra: when I only save in info in "data1" and dont need more, it also save
empty fields for "data2" and "data3"
pro: I may only scan one table to get all my infos

What do you think? I hope I did not explained to complicated :)

Greets
Chris

--0016364167f9fc44c5047b7ed979--