Contacts speed are really slow

[rodrigocoelho]

My entire espocrm is working fast and with no problem, BUT, when searching for a Contact, it is taking something like 6 seconds to give a answer. I have no more than 1500 contacts.
Any idea why?
What do you think I could do to try to optimize it?

Thanks

[item]

Hello,

version of espoCRM ? See post of Yuri

https://forum.espocrm.com/forum/installation-and-upgrade-help/60558-id-collation-changed-after-upgrade#post61212

[rodrigocoelho]

Hello,

version of espoCRM ? See post of Yuri

https://forum.espocrm.com/forum/installation-and-upgrade-help/60558-id-collation-changed-after-upgrade#post61212

Hi Item, I'm using the 6.1.5
I will try the MB4 converter Yuri posted.

The thing I never understood right is how the Indexes works. When I would have to create a index manually, as informed on the Espocrm manual?
Does it would make any difference?

Thanks Item

[rodrigocoelho]

I just did the MB4 convert, the PHP created by Yuri, and it is Fast again.
I had made the conversion by myself on the past. The collations of the tables were already MB4, I don't know what the PHP yuri created did different.

yuri