Your software
My Mautic version is: 3.3.4
My PHP version is: 7.3
My Database type and version is: Maria DB 10.3.30
Your problem
My problem is:
Contact search on Contacts page is slow, I am looking into how to speed it up. Database has around 100k - 150k contacts.
These errors are showing in the log:
[no error logs, so far]
Steps I have tried to fix the problem:
I am thinking about isolating database server from application server and give database server more ram & cpu power.
Is there anyone that has faced the same issue? How did you approach/solve it? Please share your findings here. Thanks.
joeyk
September 13, 2021, 12:44pm
2
There are multiple videos on the web regarding db speed.
Check this approach:
@joeyk , thank you for your reply. Like you suggested I found some resources and will try a couple of things.
These resources are:
https://joeykeller.com/knowledge-base-2/mautic-admin-guides/mautic-is-loading-slow-or-get-a-500-error/
https://mtcextendee.com/2019/12/25/mautic-are-very-slow-15m-contacts/
However I fail to see how installing stuff in a container would help (like it suggested in the post you mentioned). I will try some of the things I posted above first and hopefully get the results I am looking for.
Have a nice day.
1 Like