our clearspace installation has slowed down signifcantly to th point of being unusable since we created a few 1000 communties in our environement. this is with only 1 or 2 users on the system at a time.
from looking at our database load and info from Query Stats, it seems that the application is spending a lot of time repeatedly querying community info from the database
any suggestions on how we can improve the performance without removing communities?
Please verify that the community cache is sized large enough to hold most/all of the communities in your system. If that cache isn't large enough communities will continue to be loaded from the database.