I have moved Database to AWS due to low performance on local DB.
But now, All submit actions(sales order, delivery note, journal entry…) are very slow(more than 5minutes. some times timeout) than previous.
I edited query parameters as same as local to fix the issue. but no luck yet.
It may help to provide more information: Version of ERPNext, the type of AWS DB Instance (Instance class etc) your network speed and the size of your database.
Thanks for the response…
ERPNext: v12.14.0 (version-12)
Frappe Framework: v12.12.0 (version-12)
Size of the database is 9.5 GB
Check the rds configuration, increase connection limit, innovation…