CODEWITHSUNDEEP
cassandra
Kovalan R
Kovalan R

Reputation: 110

Cassandra count query takes longer time

Cassandra count query takes longer time because of million of data in the KeySpace ... increased the timeout value in caasandra.yaml also ... is there any way to improve the efficiency?? Suggestions please ..

Upvotes: 0

Views: 395

Answers (1)

doanduyhai
doanduyhai

Reputation: 8812

SELECT COUNT(*) is an expensive operation in Cassandra because it will scan all the nodes.

Try this tool, it is optimized for counting rows: https://github.com/brianmhess/cassandra-count

Upvotes: 2

Related Questions