MySQL table partitioning

[tothewine]

It may be useful on tables that become big over time like emails

[Marco]

I agree, I've 16GB of email table and all the procedure related to email are blocked. How to solve the problem?

[yuri]

16 GB is not that much. I think you can improve performance by configuring MySQL or allocating more resourses.

Full-Text search can be slow though. MySQL is very bad with full-text search when order is applied. I hope they improve it someday.

[yuri]

I think you can try to setup partitioning by yourself. It's not necceserelly must be done by application (Espo).

Full-text indexes are not supported for partition tables. https://dev.mysql.com/doc/refman/8.0...mitations.html. Full-text is enabled for emails by default.

[espcrm]

Sad to see that version 8 still have this issue, it be quite a few years before the next version.

[Marco]

Thank a lot I'll try to partition and I'll let you know. I agree with you 16GB is not so much but they're only 1 year of email data. The data obviously are increasing and function email to case takes very long time to execute

[yuri]

What exactly performs slow? When you search in contents or the list view w/o filters?

[Marco]

The performace slow is on email list show on the URL https://serveresponame/#Email is not possible to show the email list for user
Already trying in partitioning, I've to take more time