Load Testing With EspoCRM

[PSO]

Hi,

We were looking to deploy our EspoCRM app so we did some load testing to make sure it was ready for production.
The app is meant for an insurance company that has ~1000 active brokers so we tried to make sure it could handle that load and ran into some problems.

I have a few questions:

1. Does Espo have a way to cache database queries? If not, how would we go about doing it.
2. We have a setup where we handle access control through everyone having only access to entities within their team. When teams get big (many users) the query to check for access starts to take >5s. Is this normal?
3. How does everyone normally handle high usage loads on EspoCRM?


Thanks

[tanya]

Hello
Didn't try it. It could be really tough. It depends on your server (mysql server need to be very powerful).

[yuri]

Hi,

1. MySQL has own query caching.
2. What mysql version do you use? Mysql can be pretty slow when it comes to joining big tables plus sorting.

[PSO]

Hi,

1. MySQL has own query caching.
2. What mysql version do you use? Mysql can be pretty slow when it comes to joining big tables plus sorting.

The MySQL version is 5.7 and query_cache_size is set to 1MB.