How many users can I have?

Hello,

I am thinking to use Community Builder as a customer / leads database, and there would be up to 30 different fields per user profile. Most of these would be custom fields such as business name, size, amount of employees etc.

My question: How big member databases can Community Builder take and still function well and fast? Is there a member limit in the software? Is Community Builder still able to make fast searches and other processes if there are 10,000+ profiles? What are the biggest sites that people have been building with Community Builder, in terms of member amount?

Or are these factors (speed, reliability, etc) more related to the server and database instead of Community Builder itself?

Community Builder is a great software and I used it long time ago for a small community. Now I would like to use it for this, but I am very concerned that it might end up being slow and bulky when tons of profiles are in.

Thank you for answers, even estimations are welcome!

30 fields isn't a lot. We've more than that I believe and we've well over 500,000 users. So it's safe to say it can handle very large communities perfectly fine. I would recommend after setting up all your fields using Joomla debug to see what queries you use most often and add new indexes to your database tables to improve performance (not just CB tables, but any table that may need them). You can also optimize page headers with JCH Optimizer which we use and works very well (this reduced our page load times easily by 3x).

Hello Kyle,

Thank you for your reply, this was very helpful!

This part I didn't understand, but I will investigate it further: "I would recommend after setting up all your fields using Joomla debug to see what queries you use most often and add new indexes to your database tables to improve performance (not just CB tables, but any table that may need them)."

For a very large site you'll always want to add customized optimization based off the needs of your site. If you've some database queries ran regularly and unique to your site it's a good idea to optimize them as best as possible and usually means custom database indexes. This isn't anything specific to CB though and just general advise.

Ok. Thank you for this advice!