From user-return-65143-archive-asf-public=cust-asf.ponee.io@cassandra.apache.org Thu Feb 6 18:54:20 2020 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 3964018064E for ; Thu, 6 Feb 2020 19:54:20 +0100 (CET) Received: (qmail 93214 invoked by uid 500); 6 Feb 2020 18:54:17 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 93204 invoked by uid 99); 6 Feb 2020 18:54:17 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Feb 2020 18:54:17 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 08075C00CF for ; Thu, 6 Feb 2020 18:54:17 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.001 X-Spam-Level: X-Spam-Status: No, score=0.001 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, HTML_MESSAGE=0.2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-he-de.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id VFUJDmRs0Hp6 for ; Thu, 6 Feb 2020 18:54:15 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=2a00:1450:4864:20::42b; helo=mail-wr1-x42b.google.com; envelope-from=abd786.ap@gmail.com; receiver= Received: from mail-wr1-x42b.google.com (mail-wr1-x42b.google.com [IPv6:2a00:1450:4864:20::42b]) by mx1-he-de.apache.org (ASF Mail Server at mx1-he-de.apache.org) with ESMTPS id 543FB7DD70 for ; Thu, 6 Feb 2020 18:54:15 +0000 (UTC) Received: by mail-wr1-x42b.google.com with SMTP id m16so8456146wrx.11 for ; Thu, 06 Feb 2020 10:54:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=T5l76LjOdVk6NZ53emrCzaMZa5vPwi/JEjmMckbbuCg=; b=tknKvRzupE5zVMilTLDeHnEpCO9J2YX53v0YKQ7PaI0+AOy/XAvgwS2CozKxb3ExEQ RjAhrATAfZZuV//uC53AODhLImnYmiVxbInMRpGKrAukuRfiQP1go8pE6ZqIKUiRSxcL 8EHAffDelKTj3wsE4pTu+WGgcbmWD2S+1gQMyibax/cTcJYODzo2EsLcFROFL9Zkz+r2 qfXHtxSvLq30/cwzdHedLEGLDr8HrPmi1ot5vMrKfBLpCdZ1LkYJo9s4FXbKGVU7xAYH Ta255LyBda5QZ2VZhEiursn+1Uo8fMzCXSOm6mIMNDJa+eH6hKlBur/FoRLkGZh2+DaK 7ibQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=T5l76LjOdVk6NZ53emrCzaMZa5vPwi/JEjmMckbbuCg=; b=ItPF9bMB4heSk4gaXwc5Jj90uvRfZfA/6RsU6hs4ls5OOxsnQgKqK9h084pDNTddXZ wnyRqJe4k1PhWYbAepT1CwHN0Wh7e4KyqiBmFHFiMAl/wBou8Ve4NfSJZcdPyHI3H6iF 76HAC/6ivIYkIoDcQJ5iqWINjYC2oVcEaRJ9oAksRMdKsXo0nM9n0VzWmgdsVLzsYFpi AfJnKKB5G3EuaZdfwWErk/Hc9M8ThO+9Y6JRDyWfg1j/xtL2S86OF0d0O8QHU/bp3rE6 2PQ8ZndYDk5HVY9NvYYjCUVi6aJ8BVjeTSXB/YbmyEqth/Kvupdzs5I89Io5Kub4zQUZ T6WQ== X-Gm-Message-State: APjAAAUMZ2sVvXGUXb8WIx/ibtDJug22nMEU/6Sok3XnEu+VSjlGVuaH Dn+FU0sch+g6k3GFLe4Bo1QAAgQ3yVdwhblWur2S28T3 X-Google-Smtp-Source: APXvYqwLU4nrZ1uMxtEm3suiSN570VURPL8Arz8waPr7hHweqyGFdzTB/vF7hv8yudh6RtyPm0xtvW7M3yA9jpYwFl4= X-Received: by 2002:adf:fa87:: with SMTP id h7mr5549796wrr.172.1581015248614; Thu, 06 Feb 2020 10:54:08 -0800 (PST) MIME-Version: 1.0 Received: by 2002:adf:fc0c:0:0:0:0:0 with HTTP; Thu, 6 Feb 2020 10:54:07 -0800 (PST) In-Reply-To: <9b954bbd-e685-f0a6-78ad-d052148606da@pbandjelly.org> References: <9b954bbd-e685-f0a6-78ad-d052148606da@pbandjelly.org> From: Abdul Patel Date: Thu, 6 Feb 2020 13:54:07 -0500 Message-ID: Subject: Re: Running select against cassandra To: "user@cassandra.apache.org" Content-Type: multipart/alternative; boundary="000000000000473992059deccce1" --000000000000473992059deccce1 Content-Type: text/plain; charset="UTF-8" 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 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 > > --000000000000473992059deccce1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Its sort of user connected, app team needa number of active users connected= say=C2=A0 every 1 to 5 mins.
The timeout at app end is 120ms.



On Thursday, February 6, 2020, Michael Shuler <= michael@pbandjelly.org> wr= ote:
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 wron= g 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 dat= a modeling and table-relevant query. All depends on the data model and quer= y.

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

--000000000000473992059deccce1--