Performance Tweaking¶
Recommendations¶
- SSD is preferred over HDD.
- Dedicated server is preferred over shared.
- More RAM can be helpful if your database grows.
Database indexes¶
By default, EspoCRM has some pre-defined indexes. As your database gets bigger, it's reasonable to create new indexes. What exactly indexes are needed depends on how you use CRM and how you customized it: what custom fields are created, default record orders are set, reports are often run, searches are usually performed, etc.
- You need indexes for fields that are used for a default order.
- You need indexes for fields that are often used in filters (reports & regular searches).
See article about how to create indexes.
MySQL params¶
innodb_buffer_pool_size¶
It's recommended to set a value that is about 70% of your RAM.
sort_buffer_size¶
You may consider increasing this param to speed up ORDER BY or GROUP BY. See more.
innodb_log_file_size¶
Should be large enough. See more.
innodb_flush_log_at_trx_commit¶
We recommend to set it to 2
.
PHP configuration¶
Preloading¶
Since EspoCRM v6.0.0 you can use a preloading. The file preload.php
is available at the root directory.
Important: Preloading must be disabled before upgrading and extension installation.
Note: Using preloading is not likely to bring a significant performance boost. The database usually is a bottleneck in applications like CRM.
Misc¶
Disabling total count on list view¶
It is relevant if there are a lot of records of a specific entity type in the database. In this case, it can be reasonable to disable displaying count on the list view for that entity type, since COUNT can be very slow in MySQL.
To disable: Administration > Entity Manager > edit specific entity type > check Disable record count.
Use full-text search¶
Create full-text search indexes for large tables. It will improve record lookup.