Hello, I have total 12 node cluster for 6 nodes and 6 nodes divided in two racs with two datacenter. my read and write consistancy level is one and my read operation is very slow so what would be best read and write consistancy level should i configure and what are the other parameters which i need to update in my cassandra.yaml. Let me know if anybody need further details
[UPDATE] Table schema:
CREATE TABLE hhahistory.history ( tablename text, columnname text, dateyearpart bigint, tablekey bigint, updateddate timestamp, historyid bigint, appname text, audittype text, createddate timestamp, dbname text, dbsession uuid, firstname text, historybatch uuid, historycassandraid uuid, hostname text, isvlm boolean, lastname text, loginname text, newvalue text, notes text, oldvalue text, reason text, updatedby text, updatedutcdate timestamp, PRIMARY KEY ((tablename, columnname, dateyearpart), tablekey, updateddate, historyid) ) WITH CLUSTERING ORDER BY (tablekey ASC, updateddate ASC, historyid ASC)
