I want to create a simple table holding user roles e.g.

create table roles (
       name text,
       primary key(name)

If I want to get a list of roles for some admin tool I can use the following CQL3

select * from roles;

When a new name is added it will be stored on a different host and doing a select * is going to be inefficient because the table will be stored across the cluster and each node will respond. The number of roles may be less than or just greater than a dozen. I'm not sure if I'm storing the roles correctly.

The other thing I'm thinking about is that when I've read the roles once then I can cache them.


Jabbar Azam