Lack of interest Make xf_user.timezone an enum

This suggestion has been closed automatically because it did not receive enough votes over an extended period of time. If you wish to see this, please search for an open suggestion and, if you don't find any, post a new one.

digitalpoint

Well-known member
Since this column has a specific set of pre-defined values that it can be, it might not be a bad idea to make it an enum column type. It would save about 20 bytes per user record in the database and make searches against the timezone column faster. While not an insane savings, 20 bytes per user adds up when you have a lot of users.

Say for example Facebook migrated to XenForo... with only 1B users (they have more) they would save about 20GB in their database. :)
 
Upvote 6
This suggestion has been closed. Votes are no longer accepted.
Top Bottom