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
Announcement
Collapse
No announcement yet.
Contacts speed are really slow
Collapse
X
-
Originally posted by item View PostHello,
version of espoCRM ? See post of Yuri
Hi All, After upgrade (5.8.4->5.8.5->5.9.3) i found that in new version when you create new entity, primary an foreign keys are created with different collation that was before. Older one for keys was "utf8_unicode_ci", now it is utf8mb4_unicode_ci. It is a big problem because when you join fields with
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
Leave a comment:
-
Hello,
version of espoCRM ? See post of Yuri
Hi All, After upgrade (5.8.4->5.8.5->5.9.3) i found that in new version when you create new entity, primary an foreign keys are created with different collation that was before. Older one for keys was "utf8_unicode_ci", now it is utf8mb4_unicode_ci. It is a big problem because when you join fields with
Leave a comment:
-
Contacts speed are really slow
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?
ThanksTags: None
Leave a comment: