Re: Managing index tables

2013-11-06 Thread Thomas Stets
Hi Tom, thanks, I take your answer as "nobody else has found an elegant solution, either" :-) I guess I could use a secondary index for some cases, but there are several reasons I can't use them in most cases. Especially the permissions are problematic. A user may have dozens of permission for d

Re: Managing index tables

2013-11-05 Thread Tom van den Berge
Hi Thomas, I understand your concerns about ensuring the integrity of your data when having to maintain the indexes yourself. In some situations, using Cassandra's built in secondary indexes is more efficient -- when many rows contained the indexed value. Maybe your permissions fall in this categ

Managing index tables

2013-11-04 Thread Thomas Stets
What is the best way to manage index tables on update/deletion of the indexed data? I have a table containing all kinds of data fora user, i.e. name, address, contact data, company data etc. Key to this table is the user ID. I also maintain about a dozen index tables matching my queries, like nam