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 guangxing.li@pearson.com
 designates 67.231.144.81 as permitted sender)
MIME-Version: 1.0
Date: Thu, 13 Nov 2014 09:42:06 -0700
Message-ID: 
 <CABZU2BENR0UpEA=c_1o2miTYEJmDR1UoAXT+abvKtoucYhpipw@mail.gmail.com>
Subject: Is it more performant to split data with the same schema into
 multiple keyspaces, as supposed to put all of them into the same keyspace?
From: "Li, George" <guangxing.li@pearson.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=089e0153867c5e7bb70507c03165

--089e0153867c5e7bb70507c03165
Content-Type: text/plain; charset=UTF-8

Hi,
we use Cassandra to store some association type of data. For example, store
user to course (course registrations) association and user to school
(school enrollment) association data. The schema for these two types of
associations are the same. So there are two options to store the data:
1. Put user to course association data into one keyspace, and user to
school association data into another keyspace.
2. Put both of them into the same keyspace.
In the long run, such data will grow to be very large. With that in mind,
is it better to use the first approach (having multiple keyspaces) for
better performance?
Thanks.

George

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

<div dir=3D"ltr"><div>Hi,</div><div>we use Cassandra to store some associat=
ion type of data. For example, store user to course (course registrations) =
association and user to school (school enrollment) association data. The sc=
hema for these two types of associations are the same. So there are two opt=
ions to store the data:</div><div>1. Put user to course=C2=A0association=C2=
=A0data into one keyspace, and user to school=C2=A0association=C2=A0data in=
to another keyspace.</div><div>2. Put both of them into the same keyspace.<=
/div><div>In the long run, such data will grow to be very large. With that =
in mind, is it better to use the first approach (having multiple keyspaces)=
 for better performance?</div><div>Thanks.</div><div><br></div><div>George<=
/div></div>

--089e0153867c5e7bb70507c03165--