Hi,
I have a table:
CREATE TABLE json (
key text,
group text,
date timestamp,
json text,
PRIMARY KEY((key, group), date)
) WITH CLUSTERING ORDER BY (date DESC);
This table will contain a small amount of data (only what an administrator
creates by hand - a year from now maybe 6 different keys, 10-15 groups for
a total of 60-90 rows each with up to maybe 15 columns).
I need the application to detect changes to this and was planning to poll
the table every few minutes for new content (while its not often its
updated, the update needs to go live fairly quick).
My question then is how big, if any, a difference there would be to doing:
SELECT * FROM json WHERE date < :now: AND date > :lastCheck: ALLOW FILTERING
to
SELECT * FROM json WHERE key IN (<key1...key6>) AND group IN
(<group1...group15>) AND date < :now: AND date > :lastCheck:
/Kasper
