cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abdul Patel <abd786...@gmail.com>
Subject Re: Running select against cassandra
Date Thu, 06 Feb 2020 19:02:30 GMT
Also is materialized view good for production?
We are on 3.11.4

On Thursday, February 6, 2020, Abdul Patel <abd786.ap@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 <michael@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-unsubscribe@cassandra.apache.org
>> For additional commands, e-mail: user-help@cassandra.apache.org
>>
>>

Mime
View raw message