Multiple keyspace or table update for cassandra

0
votes

Is it a good idea to send batch update statements spanning multiple table? Will it generate a heavier workload on the coordination node?

1
javacassandrabatch-processingdatastaxnosql

1 Answers

0
votes

Yes it is a bad idea to send LOGGED BATCH spanning multiple partition because it can overload the coordinator.

If you need to optimize the network and don't care about batching guarantee (that all mutation will be eventually applied) user UNLOGGED BATCH