incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Olivier Mallassi <omalla...@octo.com>
Subject Secondary Index, performance , data type
Date Mon, 02 Jul 2012 15:59:15 GMT
Hi all

We have 4 indexed columns; all configured in UT8Type even if one columns is
a date and the other an integer).

1/ the read query we run can have up to 4 criteria
*select my_cf where columnA = a and columnB = b and columnC = c and columnD
= d*

This query, is fast (<500ms) up to 3 criterias but when we add the fourth
one, the exection time is 9,5s.
Do you have any ideas? is there any way to understand how cassandra
internally run the query (a kind of "explain plan")?

2/ Is there any limitations on the number of criterias we can usually have?

3/ Even if we have different data type (date, string, int), we have all
stored them as UTF8Type. Could we expect performance improvements if we use
DateType, LongType?

Many thx for all your answers.

-- 
............................................................
Olivier Mallassi
OCTO Technology
............................................................
50, Avenue des Champs-Elysées
75008 Paris

Mobile: (33) 6 28 70 26 61
Tél: (33) 1 58 56 10 00
Fax: (33) 1 58 56 10 01

http://www.octo.com
Octo Talks! http://blog.octo.com

Mime
View raw message