We are using RDS (MySQL instance) as data source for Camunda. Everything works fine, but performance very worst. It was taking too long to connect database and it was taking too much of time for processing also. ex. login takes more than a minute. Listing the users(Camunda Admin UI) is also taking too much of time.
Is it better approach to use RDS with Camunda? I can’t tolerate the RDS performance. Amazon is concentrating on provisioning/IOPS based pricing on RDS rather than focusing on improving DB performance.
If I use H2 or MySQL(not as RDS instance) it performs very fast.
Suggest some solutions and let us know how it works better if i try to integrate with MongoDB. I hope camunda won’t support MongoDB.