Greetings,
We are planning to use Camunda BPM engine, while going through best practices we noticed Oracle and postgresql are advised. Any specific factors for not recommending highly on MS SQL ? Please advise.
Thank you
Rathinakarthik
Greetings,
We are planning to use Camunda BPM engine, while going through best practices we noticed Oracle and postgresql are advised. Any specific factors for not recommending highly on MS SQL ? Please advise.
Thank you
Rathinakarthik
Nothing massively significant. We usually see slightly better performance for PostgreSQL and Oracle. We also know that the majority of people using Camunda use those databases so at this point any issues relating to configuration has likely already been discovered and fixed.
We generally suggest that if you have no existing preference it’s best to use PostgreSQL and Oracle but if you’ve already got a preference for any other reason (e.g. you already know have experience with another database) than go with your preference.
@Niall Thank you for your response. Oracle/Postgresql performance - is it observed better in process engine/cockpit, can you please share us any benchmark test if you have.
It difference wouldn’t really be observable unless you’re pushing the engine very hard.
If you’re interested, you can check out and run the benchmarks we use from github