{"action":"created","issue":{"url":"https://api.github.com/repos/openzipkin/zipkin/issues/1224","repository_url":"https://api.github.com/repos/openzipkin/zipkin","labels_url":"https://api.github.com/repos/openzipkin/zipkin/issues/1224/labels{/name}","comments_url":"https://api.github.com/repos/openzipkin/zipkin/issues/1224/comments","events_url":"https://api.github.com/repos/openzipkin/zipkin/issues/1224/events","html_url":"https://github.com/openzipkin/zipkin/issues/1224","id":170338006,"number":1224,"title":"Refactor duration query in cassandra","user":{"login":"adriancole","id":64215,"avatar_url":"https://avatars.githubusercontent.com/u/64215?v=3","gravatar_id":"","url":"https://api.github.com/users/adriancole","html_url":"https://github.com/adriancole","followers_url":"https://api.github.com/users/adriancole/followers","following_url":"https://api.github.com/users/adriancole/following{/other_user}","gists_url":"https://api.github.com/users/adriancole/gists{/gist_id}","starred_url":"https://api.github.com/users/adriancole/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adriancole/subscriptions","organizations_url":"https://api.github.com/users/adriancole/orgs","repos_url":"https://api.github.com/users/adriancole/repos","events_url":"https://api.github.com/users/adriancole/events{/privacy}","received_events_url":"https://api.github.com/users/adriancole/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2016-08-10T06:31:05Z","updated_at":"2016-08-10T06:31:10Z","closed_at":null,"body":"_From @adriancole on May 6, 2016 0:59_\n\nThe duration query is the most expensive query in cassandra, as it turns into 1 request per hour of lookback, limited to indexTtl. The UI's default lookback is a day, so this means 24 requests to the backend. If someone sets the ui to an early time, it limits at index TTL, which defaults to 7 days or 168 requests!\r\n\r\nWe should look into alternatives, perhaps doing a \"peek\" at the first bucket and only proceeding to fan out if that doesn't meet the response limit. Since the response limit is often 10, it might actually be fine.\r\n\r\nSee #199 \r\n\r\ncc @eirslett @yurishkuro @danchia\n\n_Copied from original issue: openzipkin/zipkin-java#200_"},"comment":{"url":"https://api.github.com/repos/openzipkin/zipkin/issues/comments/238777348","html_url":"https://github.com/openzipkin/zipkin/issues/1224#issuecomment-238777348","issue_url":"https://api.github.com/repos/openzipkin/zipkin/issues/1224","id":238777348,"user":{"login":"adriancole","id":64215,"avatar_url":"https://avatars.githubusercontent.com/u/64215?v=3","gravatar_id":"","url":"https://api.github.com/users/adriancole","html_url":"https://github.com/adriancole","followers_url":"https://api.github.com/users/adriancole/followers","following_url":"https://api.github.com/users/adriancole/following{/other_user}","gists_url":"https://api.github.com/users/adriancole/gists{/gist_id}","starred_url":"https://api.github.com/users/adriancole/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adriancole/subscriptions","organizations_url":"https://api.github.com/users/adriancole/orgs","repos_url":"https://api.github.com/users/adriancole/repos","events_url":"https://api.github.com/users/adriancole/events{/privacy}","received_events_url":"https://api.github.com/users/adriancole/received_events","type":"User","site_admin":false},"created_at":"2016-08-10T06:31:10Z","updated_at":"2016-08-10T06:31:10Z","body":"Here's what a duration query looks like right now\r\n\r\n![screen shot 2016-05-07 at 5 01 27 pm](https://cloud.githubusercontent.com/assets/64215/15091253/8dff4b60-1475-11e6-8521-a2e8840dfa8e.png)\r\n"}}
{"actor":{"display_login":"adriancole"}}