Also is materialized view good for production? We are on 3.11.4 On Thursday, February 6, 2020, Abdul Patel <abd786...@gmail.com> wrote:
> Its sort of user connected, app team needa number of active users > connected say every 1 to 5 mins. > The timeout at app end is 120ms. > > > > On Thursday, February 6, 2020, Michael Shuler <mich...@pbandjelly.org> > wrote: > >> 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 >> >>
