Hello,
For a web project I am currently working on I need to create a user table. Right now I plan to have about 30 fields in this table.. I don't know how many rows the table will end up with but I want to plan now for later..
Several of the fields will be included in WHERE statements and I am using MYSQL 3.23.36.
I am wondering if it is better to have one table with many fields (including blob/text) or 2-3 small tables that i could join together when getting data?
Explain: Having just a "users" table or "users", "profiles", "preferences" etc?
Also, are there any performance differences between blobs,texts fields?
Regards,
Kevin Young
For a web project I am currently working on I need to create a user table. Right now I plan to have about 30 fields in this table.. I don't know how many rows the table will end up with but I want to plan now for later..
Several of the fields will be included in WHERE statements and I am using MYSQL 3.23.36.
I am wondering if it is better to have one table with many fields (including blob/text) or 2-3 small tables that i could join together when getting data?
Explain: Having just a "users" table or "users", "profiles", "preferences" etc?
Also, are there any performance differences between blobs,texts fields?
Regards,
Kevin Young