if each column value pertains to only the user, then no, don't split the user table
if any of the columns contains multiple values, e.g. "interests", and you want the individual values to be searchable (instread of the whole thing as a single string which contains text/narrative), then yes, split that off
thank you for your reply.
Im planning on splitting the 'experise' column into a separate table. I have roughly 50+ expertise (e.g. asp, php, html etc..) for users to choose from.
Should I build the table with 50+ columns and record the user expertise one per row, or should I build the table with only 2 main columnes (i.e. user id, expertise) which will split user expertise into several rows.
My concern is with the database memory and searching speed once I have more users.
Let's say if I have 50 columns per row and users only know three types of expertise then would it be better off to split the user into three different rows instead of storing data in the same row with 47 redundant columns?