How to search User (Entity) columns without sec. index?

2012-11-09 Thread Alan Ristić
Here is the thing. I'm modelling User entity and got to problem with searching trough user columns. CREATE TABLE users ( user_uuid uuid PRIMARY KEY, date_created timestamp, password varchar, username varchar, name varchar, first_name varchar, last_name varchar, email varchar,

Re: How to search User (Entity) columns without sec. index?

2012-11-09 Thread Alain RODRIGUEZ
I think there is just a few solutions. - Secondary index on username - CF used as an index (store username as row and all the uuid of users with this username as columns) - Get all the data and filter after (really poor performances depending on the size of the data set) I can't see an other way