Performance Question

[merrickswatchorn]

Greetings,

I was hoping to find out at what point does performance start to take a hit, based on users? My implementation could very well exceed 20,000 users with more in the future. At what point does the storage start to interfere with the application layer?

Maverick

[ruchida]

Hi,

I think there are two major factors that may cause slow performance. One is the number of users and the other is the number of records. Lots of active users will hit the limit of CPU or memory very easily. This is already explained in many places including Sugar Wiki.

I've experienced awfully bad performance with more than 100,000 records in either of Contacts, Emails, Cases tables. This is caused by two types of bad queries SugarCRM issues - count and concat. Particularly the concat at the SQL level sometimes takes more than a minute to display a listview and makes SugarCRM halt. Any index never worked. I needed to remove this query and restructure the MySQL scheme to improve the performance.