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

[account8226]

Hello,

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.

 

[Chris D]

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]

Do you mean columns?

1 row = 1 user.

Columns are user_id, username etc.

Additional columns aren't usually too much of an issue.

Yes sorry I meant columns lol ^^

So having some columns aren't really a problem ?

 

[Chris D]

I wouldn't worry too much

 

[account8226]

I wouldn't worry too much

Great thanks you very much Chris

 

[SneakyDave]

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

 

[Reeve of Shinra]

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

 

[tyteen4a03]

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

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