Hello, we have a client with an online community with almost 500.000 users. We want to offer jomsocial as a solution to improve his socialengine community, but we need to know if jomsocial can handle that kind of community. If we convert each user to the jomsocial bd format, this will generate more than 30 millions of data rows (in user fields). Each user have 64 rows in the clients db. Also, this community has more than 500 to 1500 in special days concurrent users.
So our question is: jomsocial is able to use a normal mysql table for users information (custom fields?) or the only way is the actual implementation with user fields?
What we need to know is if we are able to change the jomsocial fields, fields_values structure, to normal table columns for keep the sql queries performance. ¿Do you understand? ¿ jomsocial can handle this without need to change the source code?
So do you mean to change the current multiple Jomsocial table to one user table stucture for making it fast ? that is not possible, you cant change any database jomsocial structure.
You have huge database records, the solution is you should tweak the database configuration and install some 3rd party cache for making your site faster.
