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

Having more than 50 rows in "xf_user" could be a performance problem ?

Discussion in 'XenForo Development Discussions' started by account8226, Apr 22, 2013.

  1. account8226

    account8226 Guest


    I wanted to know if having a lot of columns in a xf_user table could lead to performance problems (load time).

    As an example, when we use <xen:username> tags, isn't it loading all the user database line's ?

    Would you suggest me to add one or two more columns in xf_user, or making a full new tabs for theses 2 datas I have to store ?

    Best regards.
  2. Chris D

    Chris D XenForo Developer Staff Member

    Do you mean columns?

    1 row = 1 user.

    Columns are user_id, username etc.

    Additional columns aren't usually too much of an issue.
    account8226 likes this.
  3. account8226

    account8226 Guest

    Yes sorry I meant columns lol ^^

    So having some columns aren't really a problem ?
  4. Chris D

    Chris D XenForo Developer Staff Member

    I wouldn't worry too much :)
    account8226 likes this.
  5. account8226

    account8226 Guest

    Great thanks you very much Chris :)
  6. SneakyDave

    SneakyDave Well-Known Member

    Only "problem" would be space, in my opinion, but that would apply to rows and columns.
  7. Reeve of Shinra

    Reeve of Shinra Well-Known Member

    You may want to add these as custom fields. I believe that would better
  8. tyteen4a03

    tyteen4a03 Well-Known Member

    Actually, no, especially if it is accessed frequently. Only JOIN if you have to.

Share This Page