You'll have to be more specific. What is your table schema and what is the SELECT query? What is the normal response time?

As a basic guide for your general question, if the query is something sort of irrelevant that should be stored some other way, like a total row count, or most any SELECT that requires ALLOW FILTERING, you're doing it wrong and should re-evaluate your data model.

1 query per minute is a minuscule fraction of the basic capacity of queries per minute that a Cassandra cluster should be able to handle with good data modeling and table-relevant query. All depends on the data model and query.

Michael

On 2/6/20 12:20 PM, Abdul Patel wrote:
Hi,

Is it advisable to run select query to fetch every minute to grab data from cassandra for reporting purpose, if no then whats the alternative?



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
For additional commands, e-mail: user-h...@cassandra.apache.org

Reply via email to