ERPNEXT Remote Database(AWS) very slow submit operations

ERPNext
1

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.

2

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.

3

Thanks for the response…

ERPNext version
ERPNext: v12.14.0 (version-12)
Frappe Framework: v12.12.0 (version-12)

AWS DB
Instance class:db.t4g.xlarge
vCPU:4
RAM:16 GB
Engine:MariaDB

Size of the database is 9.5 GB

4

Check the rds configuration, increase connection limit, innovation…