Have anyone experience this. I suddenly notice my server to take 40 minutes to complete submit or cancel an stock entry. The last time I remember, it was 3 minutes. I do not even noticed that there was an increment in time. It just suddenly boom - now it need 40 minutes.
I try to increase memory, CPU and guni workers but there is no relevant assignable cause as I observed.
My server specs:
CPU: 8 cores
Memory: 16 GB
Storage: 80 GB
Worker: 9
The Profiling and Monitoring tools could become your best ally.
https://frappeframework.com/docs/user/en/profiling
“If you’ve noticed that a certain DocType is taking too much time to save and you believe that SQL queries might be a bottleneck. In such a case starting recorder and then submitting your document will give you complete capture of all the queries that were fired for saving the document.”
Look like it is something we have to live for now. Anyways, thank you @thinkdigital .