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
