Performance Tuning - Account Lookup

[sleddie61]

Good morning:

Have been using the app for a coupla years now. Love it. Getting some performance slowdown when doing basic account searches. I'm smart enough to be dangerous but could use a point in the right direction to figure out how to reduce the delay when doing account searches. Seems as though it's doing a full table scan (initially) prior to displaying the search result.

Any help would be appreciated.

[macistda]

Maybe you should think about a database optimization. Example for mysql / mariadb look here:

https://forum.espocrm.com/forum/general/87384-trimming-database-filesize

Please remember, backup before.

[yuri]

https://docs.espocrm.com/administration/performance-tweaking/

What may help:

• Creating indexes;
• Enabling full-text search;
• Disabling total count calculation;
• DB settings tweaking.

[sleddie61]

Thank you for the recommendations. Yuri, I have ready the performance tweaking recommendations but have questions:

1. Account search seems to be doing a full table scan. I assume there are built-in indexes that have already been built for Account name lookups?
2. Where can I find info on how to enable full-text searches?
3. Total count has been disabled.
4. Will look into tweaking db settings.

Appreciate the help.

[yuri]

Check what fields you have activated for text search for Account: Administration > Entity Manager > Account > Edit > Text Filter Fields.

If it's only name and email, then the problem might be with the email, as we have the index for the "name". Or the index is not applied for some reason.

> 2. Where can I find info on how to enable full-text searches?

In the same article, the link: https://docs.espocrm.com/administrat...ll-text-search