cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Li, George" <guangxing...@pearson.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?
Date Thu, 13 Nov 2014 16:42:06 GMT
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

Mime
View raw message