Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

shehzadjahagirdar_185613 avatar image
shehzadjahagirdar_185613 asked Erick Ramirez answered

What could be the reason query between 2 tables containing the same data take 1s and 4s?

I have 2 tables with exact same data on it.When we run cqlsh query on table 1 output returns within 1 sec whereas cqlsh query on table 2 returns output in 4 seconds.What could be the possible reasons for this.

performance
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered

Without a copy of the table schema and the query you're running, it's impossible for us to know what's going on with your cluster but my guess is that you're not comparing apples-for-apples.

My suggestion is that you run the query with tracing enabled and see where the request spends most of its time for clues. Cheers!

Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.