{"action":"created","issue":{"url":"https://api.github.com/repos/krasserm/akka-persistence-cassandra/issues/135","labels_url":"https://api.github.com/repos/krasserm/akka-persistence-cassandra/issues/135/labels{/name}","comments_url":"https://api.github.com/repos/krasserm/akka-persistence-cassandra/issues/135/comments","events_url":"https://api.github.com/repos/krasserm/akka-persistence-cassandra/issues/135/events","html_url":"https://github.com/krasserm/akka-persistence-cassandra/issues/135","id":119595474,"number":135,"title":"Deleting message generates batches of single delete","user":{"login":"masterzen","id":20242,"avatar_url":"https://avatars.githubusercontent.com/u/20242?v=3","gravatar_id":"","url":"https://api.github.com/users/masterzen","html_url":"https://github.com/masterzen","followers_url":"https://api.github.com/users/masterzen/followers","following_url":"https://api.github.com/users/masterzen/following{/other_user}","gists_url":"https://api.github.com/users/masterzen/gists{/gist_id}","starred_url":"https://api.github.com/users/masterzen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/masterzen/subscriptions","organizations_url":"https://api.github.com/users/masterzen/orgs","repos_url":"https://api.github.com/users/masterzen/repos","events_url":"https://api.github.com/users/masterzen/events{/privacy}","received_events_url":"https://api.github.com/users/masterzen/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-11-30T22:26:38Z","updated_at":"2015-12-02T08:03:55Z","closed_at":null,"body":"This is more a question than an issue.\r\n\r\nIf you look at how messages are deleted, the Akka API just allows to tell up to which `sequence_nr` you want to delete the messages.\r\nThe current implementation is building a batch of single deletion of the 'record' `((persistence_id, partition_nr), sequence_nr)` for all `sequence_nr` from lowest to the given `sequence_nr`. All the batches are submitted in parallel.  \r\n\r\nWhat is the reason not using a per-partition query like `DELETE FROM messages WHERE persistence_id = ? AND partition_nr = ? AND sequence_nr <= ?`. \r\nThis would probably allow to use a cassandra range query and would be faster, isn't it?\r\n"},"comment":{"url":"https://api.github.com/repos/krasserm/akka-persistence-cassandra/issues/comments/161214152","html_url":"https://github.com/krasserm/akka-persistence-cassandra/issues/135#issuecomment-161214152","issue_url":"https://api.github.com/repos/krasserm/akka-persistence-cassandra/issues/135","id":161214152,"user":{"login":"krasserm","id":202907,"avatar_url":"https://avatars.githubusercontent.com/u/202907?v=3","gravatar_id":"","url":"https://api.github.com/users/krasserm","html_url":"https://github.com/krasserm","followers_url":"https://api.github.com/users/krasserm/followers","following_url":"https://api.github.com/users/krasserm/following{/other_user}","gists_url":"https://api.github.com/users/krasserm/gists{/gist_id}","starred_url":"https://api.github.com/users/krasserm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/krasserm/subscriptions","organizations_url":"https://api.github.com/users/krasserm/orgs","repos_url":"https://api.github.com/users/krasserm/repos","events_url":"https://api.github.com/users/krasserm/events{/privacy}","received_events_url":"https://api.github.com/users/krasserm/received_events","type":"User","site_admin":false},"created_at":"2015-12-02T08:03:54Z","updated_at":"2015-12-02T08:03:54Z","body":"Ah didn't see that for Cassandra 3. @patriknw and @zapletal-martin are working on the [Cassandra 3](https://github.com/krasserm/akka-persistence-cassandra/tree/cassandra-3.x) branch. This would be a nice addition there."}}