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
