On Wed, Jan 18, 2012 at 7:31 AM, Eric Martell <workoutexc...@yahoo.com> wrote: > Hi, > > I am having 10 millions of rows with in sql db in key table. > > key_id -> key_value > > > For each request I am fetching one key_id and removing that > from the key table. Each request should get unique key_id. Similar to > java queue but keys persists in DB. > > How do I implement that in Cassandra and what is the best way to achieve this?
Why Cassandra and not a real queue implementation? My first advice would usually be just "don't", since deletion is done by tombstoning. What may work better is store payload in Cassandra and send ids separately; this is how we did a queueing system with AWS (SQS for passing ids, S3 for storing payload) -+ Tatu +-
