It may be useful on tables that become big over time like emails
Announcement
Collapse
No announcement yet.
MySQL table partitioning
Collapse
X
-
I agree, I've 16GB of email table and all the procedure related to email are blocked. How to solve the problem?
-
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.Last edited by yuri; 06-17-2021, 05:22 PM.
Comment
-
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
Comment
-
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
Comment
Comment