Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of tyler@datastax.com designates
 209.85.212.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CANyhWhT4D6S3MTDJP4b=-8u=fUnO0igooYc-yYGTVE90CWq0KQ@mail.gmail.com>
References: 
 <CA+VSrLpiqUGG6PP=h_fR9qwdd=sr4pzzGHfLy9YuwEkHJfP4jg@mail.gmail.com>
	<CC46B404.17534%r0rajag@wal-mart.com>
	<CANyhWhT4D6S3MTDJP4b=-8u=fUnO0igooYc-yYGTVE90CWq0KQ@mail.gmail.com>
Date: Sat, 11 Aug 2012 15:42:55 -0500
Message-ID: 
 <CAAam9stj65-8yJ6zcRBfEQ6wptQvcERELE2L-uAuQKrUtem26w@mail.gmail.com>
Subject: Re: Project Management
From: Tyler Hobbs <tyler@datastax.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=20cf307ac79b50592e04c70381d9

--20cf307ac79b50592e04c70381d9
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Aug 7, 2012 at 2:32 AM, Baskar Sikkayan <baskar.sks@gmail.com>wrote:

>
> If i create one more column family based on my query instead of going with
> secondary index,
> Will it affect the write performance?
>

It won't affect writes much more than the built-in secondary indexes would,
and you'll get better read performance.


> Since i need to duplicate the data in the second column family as well
> while writing data, Will it hit write performance?


Same answer.

-- 
Tyler Hobbs
DataStax <http://datastax.com/>

--20cf307ac79b50592e04c70381d9
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div class=3D"gmail_quote">On Tue, Aug 7, 2012 at 2:32 AM, Baskar Sikkayan =
<span dir=3D"ltr">&lt;<a href=3D"mailto:baskar.sks@gmail.com" target=3D"_bl=
ank">baskar.sks@gmail.com</a>&gt;</span> wrote:<br><blockquote class=3D"gma=
il_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-lef=
t:1ex">
<br>If i create one more column family based on my query instead of going w=
ith secondary index,<br>Will it affect the write performance?<br></blockquo=
te><div><br>It won&#39;t affect writes much more than the built-in secondar=
y indexes would, and you&#39;ll get better read performance.<br>
=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left:1px solid rgb(204,204,204);padding-left:1ex">Since i need to =
duplicate the data in the second column family as well while writing data, =
Will it hit write performance?</blockquote>
</div><br>Same answer.<br clear=3D"all"><br>-- <br><font color=3D"#888888">=
Tyler Hobbs<span></span><br>
<a href=3D"http://datastax.com/" target=3D"_blank">DataStax</a><br></font><=
br>

--20cf307ac79b50592e04c70381d9--