Efficiently storing data from a string, into mysql?

I am trying to process data in java for a given string like this:

userName[category=12, userAgeType=teen, fast=true, athlete=false, mood=happy]

Along with some additional data. A user doesn't always have all the values. e.g. a user could look like this:

userName[category=12, mood=happy]

Or even just have a userName without this data. As I am trying to ensure the db is not overloaded with unnecessary data, is there an efficient way of storing this data? Users can often have identical values. I was thinking of storing the data into another table with an primary key(id)...

Read More »

By: StackOverFlow - Friday, 9 November

Related Posts