1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Make xf_user.timezone an enum

Discussion in 'XenForo Suggestions' started by digitalpoint, Sep 15, 2013.

  1. digitalpoint

    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. :)
     
    Khaleal, Ketola, Sage Knight and 3 others like this.

Share This Page