Return-Path: 
 <user-return-44641-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org>
X-Original-To: apmail-cassandra-user-archive@www.apache.org
Delivered-To: apmail-cassandra-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id B1C10C521
	for <apmail-cassandra-user-archive@www.apache.org>;
 Wed,  7 Jan 2015 18:51:41 +0000 (UTC)
Received: (qmail 43462 invoked by uid 500); 7 Jan 2015 18:51:39 -0000
Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org
Received: (qmail 43417 invoked by uid 500); 7 Jan 2015 18:51:39 -0000
Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cassandra.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cassandra.apache.org>
List-Post: <mailto:user@cassandra.apache.org>
List-Id: <user.cassandra.apache.org>
Reply-To: user@cassandra.apache.org
Delivered-To: mailing list user@cassandra.apache.org
Received: (qmail 43407 invoked by uid 99); 7 Jan 2015 18:51:39 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jan 2015 18:51:39 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of rcoli@eventbrite.com
 designates 209.85.216.182 as permitted sender)
Received: from [209.85.216.182] (HELO mail-qc0-f182.google.com)
 (209.85.216.182)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jan 2015 18:51:34 +0000
Received: by mail-qc0-f182.google.com with SMTP id r5so1352582qcx.27
        for <user@cassandra.apache.org>; Wed, 07 Jan 2015 10:49:43 -0800 (PST)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20130820;
        h=x-gm-message-state:mime-version:in-reply-to:references:date
         :message-id:subject:from:to:content-type;
        bh=6RdTNifk/HAT0fTNBnQW9Wx4YOcWkoXIE76ooEJ+GuM=;
        b=ZxHR353K/QbPo5DT8ibn6lsx9xwgISL+pM7Y2H+yGVFjqp2f+DQ1pV5o1WjQQ91JAZ
         LfjJDdDBjbKyYH8HLUBsz/+FstXCn2s+aPpn8XIgo2LPPUeAnIZMbGh9FBfFsj5UlYLw
         3DP2KkK1F1YRrEl62ri/mhETGsvBtFEzEJ+NWvx+3Uo0oza900xwYqd0lpDZOReuk0Tx
         u1R/707ZAIST7wC9W++D/uv4ywv1ojUv5xPACViA80owruoFbtrD2X6CvEW58Z5vuqkj
         KvF0tLbRpa8jUR3KVAxaj5oWWrYGj5uTRSX/XBGIFDNDgR75RQ34B5uDJR7CHg6rnZuc
         F0JQ==
X-Gm-Message-State: 
 ALoCoQlJ3DzcmFJ2xUHIxa3I0vlm7BGMuq5jU0auGxOc+I/B1wn0WIp2htULiyaR4O87wD//1q6B
MIME-Version: 1.0
X-Received: by 10.224.3.137 with SMTP id 9mr7492727qan.64.1420656583136; Wed,
 07 Jan 2015 10:49:43 -0800 (PST)
Received: by 10.229.133.79 with HTTP; Wed, 7 Jan 2015 10:49:43 -0800 (PST)
In-Reply-To: 
 <CA+Gcq=_2Ti0A1rBHCtaA2HgCKYExjX4Pxb_Q=PAkRjV5V8pjqA@mail.gmail.com>
References: 
 <CA+Gcq=_2Ti0A1rBHCtaA2HgCKYExjX4Pxb_Q=PAkRjV5V8pjqA@mail.gmail.com>
Date: Wed, 7 Jan 2015 10:49:43 -0800
Message-ID: 
 <CAEDUwd1rmrKf1JDZ5kL=gtFvpunTR_e3TXQjrnMrScuLK+kgmw@mail.gmail.com>
Subject: Re: Are Triggers in Cassandra 2.1.2 performace Hog??
From: Robert Coli <rcoli@eventbrite.com>
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=001a11c2480afc8a3a050c146208
X-Virus-Checked: Checked by ClamAV on apache.org

--001a11c2480afc8a3a050c146208
Content-Type: text/plain; charset=UTF-8

On Wed, Jan 7, 2015 at 5:40 AM, Asit KAUSHIK <asitkaushiknosql@gmail.com>
wrote:

> We are trying to integrate elasticsearch with Cassandra and as the river
> plugin uses select * from any table it seems to be bad performance choice.
> So i was thinking of inserting into elasticsearch using Cassandra trigger.
> So i wanted your view does a Cassandra Trigger impacts the performance of
> read/Write of Cassandra.
>

I would not use triggers in production in their current form.

=Rob

--001a11c2480afc8a3a050c146208
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra"><div class=3D"gmail_quote">On W=
ed, Jan 7, 2015 at 5:40 AM, Asit KAUSHIK <span dir=3D"ltr">&lt;<a href=3D"m=
ailto:asitkaushiknosql@gmail.com" target=3D"_blank">asitkaushiknosql@gmail.=
com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr=
"><div>We are trying to integrate elasticsearch with Cassandra and as the r=
iver plugin uses select * from any table it seems to be bad performance cho=
ice. So i was thinking of inserting into elasticsearch using Cassandra trig=
ger.</div><div>So i wanted your view does a Cassandra Trigger impacts the p=
erformance of read/Write of Cassandra.</div></div></blockquote><div><br></d=
iv><div>I would not use triggers in production in their current form.</div>=
<div><br></div><div>=3DRob=C2=A0</div></div></div></div>

--001a11c2480afc8a3a050c146208--