cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apoorva Gaurav <>
Subject Re: Read performance in map data type
Date Wed, 02 Apr 2014 03:15:11 GMT
Thanks Sourabh,

I've modelled my table as "studentID int, subjectID int, marks int, PRIMARY
KEY(studentID, subjectID)" as primarily I'll be querying using studentID
and sometime using studentID and subjectID.

I've tried driver 2.0.0 and its giving good results. Also using its auto
paging feature. Any idea what should be a typical value for fetch size. And
does the fetch size depends on how many columns are there in the CQL table
for e.g. should fetch size in a table like "studentID int, subjectID int,
marks1 int, marks2 int, marks3 int.... marksN int PRIMARY KEY(studentID,
subjectID)" be less than fetch size in "studentID int, subjectID int, marks
int, PRIMARY KEY(studentID, subjectID)"

On Wed, Apr 2, 2014 at 2:20 AM, Robert Coli <> wrote:

>  On Mon, Mar 31, 2014 at 9:13 PM, Apoorva Gaurav <
>> wrote:
>> Thanks Robert, Is there a workaround, as in our test setups we keep
>> dropping and recreating tables.
> Use unique keyspace (or table) names for each test? That's the approach
> they're taking in 5202...
> =Rob

Thanks & Regards,

View raw message