Skip to content

Performance Tweaking


  • 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


It's recommended to set a value that is about 70% of your RAM.


You may consider increasing this param to speed up ORDER BY or GROUP BY. See more.


Should be large enough. See more.


We recommend to set it to 2.

PHP configuration


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.


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.

Create full-text search indexes for large tables. It will improve record lookup.