We recently migrated our application with cockroachDB. Earlier application was using MySQL.
I have a concern regarding Query performance. I am using Apache JMeter for testing.
While I am sending 500 requests with single user via JMeter, I got following results: -
Avg Transaction processing time: 1465ms
Number of Cockroach Nodes: 3
Avg Transaction processing time: 631ms
So, as a conclusion, I think MySql is winner in terms of Performance.
Is there a way to improve my application processing time with CockroachDB? In application,I am using Java JPA for CRUD operation.