High CPU on Query

[phambryan]

After loading index into our Cassandra Cluster (7 nodes : 16 cores /32gb per node) with 10M rows.

On load testing of 100 req/s we're seeing 100% CPU on filter.

Is there any way to optimize Lucene Cassandra Index so it wouldn't peg our cluster ?

[ealonsodb]

Hi @phambryan:

Could you please show us the related filter query ?

[phambryan]

SELECT * FROM users WHERE expr(users_index, '{ filter: { type: "wildcard", field: "food", value: "*tu*" } }');

The offending query is a double wildcard *term*; it seems that for Phrase is a better approach to lower CPU consumption.