I wanted to get some inputs for using CockroachDB as a store to keep all the transactional data that are being pushed to kafka in realtime, the tables can have less than a week /month of data which gets updated based on the changed data received from Kafka. I wanted to know few things like
- How frequent can be the updates? Is bulk/batch updates every few minutes is good?
- How would be the query performance in terms of complex joins and concurrent queries?