This may fall into the category of over-optimization but I've become curious.
I have a user table with about 14 columns that are all 1:1 data - so they can't be normalized.
When I insert a row all columns need to be set. But when I update, I sometimes only update 1-2 columns at a time. Does the number of columns impact update speed?
For example:
UPDATE users SET email = ? WHERE id = ?;
I can easily break this up into logical tables like user_profile, user_credential, user_contact_info, user_summary, etc with each table only having 1-4 columns. But with the multiple tables I would often be joining them to bring back a collection of columns.
I know I'm over thinking this but I'm curious of what the performance trade offs are for breaking up a table into smaller logically grouped tables.
Thanks.
