Attributes Vs dedicated table
Permalink
Hello all
Say I have registered users and I am saving data for each, says customer_id (different from user ID), birthday, and country.
What would be the benefits/Drawbacks of putting the data in user attributes instead of in a dedicated table in the database?
In terms of speed mostly but I'm interested in any other aspect you might think of.
One thing I can think of is data management. If I use attributes and someone manually deletes a user, the data disappears with it but if I have it in a table, the data survives which might force me to check every time whether the user still exists or not.
Any other idea?
Thank you
Say I have registered users and I am saving data for each, says customer_id (different from user ID), birthday, and country.
What would be the benefits/Drawbacks of putting the data in user attributes instead of in a dedicated table in the database?
In terms of speed mostly but I'm interested in any other aspect you might think of.
One thing I can think of is data management. If I use attributes and someone manually deletes a user, the data disappears with it but if I have it in a table, the data survives which might force me to check every time whether the user still exists or not.
Any other idea?
Thank you
Bump...