Hi Everyone

I have a question with regards read performance and schema design if someone 
could help please.


Our requirement is to store per user, many unique results (which is basically 
an attempt at some questions ..) so I had thought of having the userid as the 
row key and the result id as columns. 

The keys  for the result ids are maintained in a separate location so are known 
without having to perform any additional lookups.

My concern is that over time reading a single result would incur the overhead 
of reading the entire row from disk so gradually slow things down.


So I was considering if changing the row key to userid + result id would be a 
better solution ?



Cheers
Ben

Reply via email to