{"action":"created","issue":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/4909","labels_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/4909/labels{/name}","comments_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/4909/comments","events_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/4909/events","html_url":"https://github.com/rethinkdb/rethinkdb/issues/4909","id":109381927,"number":4909,"title":"orderBy.slice / orderBy.limit.skip changefeeds","user":{"login":"danielmewes","id":505365,"avatar_url":"https://avatars.githubusercontent.com/u/505365?v=3","gravatar_id":"","url":"https://api.github.com/users/danielmewes","html_url":"https://github.com/danielmewes","followers_url":"https://api.github.com/users/danielmewes/followers","following_url":"https://api.github.com/users/danielmewes/following{/other_user}","gists_url":"https://api.github.com/users/danielmewes/gists{/gist_id}","starred_url":"https://api.github.com/users/danielmewes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danielmewes/subscriptions","organizations_url":"https://api.github.com/users/danielmewes/orgs","repos_url":"https://api.github.com/users/danielmewes/repos","events_url":"https://api.github.com/users/danielmewes/events{/privacy}","received_events_url":"https://api.github.com/users/danielmewes/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/labels/tp:ReQL_proposal","name":"tp:ReQL_proposal","color":"0052cc"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/milestones/41","html_url":"https://github.com/rethinkdb/rethinkdb/milestones/subsequent","labels_url":"https://api.github.com/repos/rethinkdb/rethinkdb/milestones/41/labels","id":367201,"number":41,"title":"subsequent","description":"","creator":{"login":"coffeemug","id":48436,"avatar_url":"https://avatars.githubusercontent.com/u/48436?v=3","gravatar_id":"","url":"https://api.github.com/users/coffeemug","html_url":"https://github.com/coffeemug","followers_url":"https://api.github.com/users/coffeemug/followers","following_url":"https://api.github.com/users/coffeemug/following{/other_user}","gists_url":"https://api.github.com/users/coffeemug/gists{/gist_id}","starred_url":"https://api.github.com/users/coffeemug/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coffeemug/subscriptions","organizations_url":"https://api.github.com/users/coffeemug/orgs","repos_url":"https://api.github.com/users/coffeemug/repos","events_url":"https://api.github.com/users/coffeemug/events{/privacy}","received_events_url":"https://api.github.com/users/coffeemug/received_events","type":"User","site_admin":false},"open_issues":336,"closed_issues":2,"state":"open","created_at":"2013-06-30T07:32:52Z","updated_at":"2015-10-01T20:54:59Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2015-10-01T20:54:59Z","updated_at":"2015-10-01T21:14:12Z","closed_at":null,"body":"This came up in https://github.com/rethinkdb/rethinkdb/issues/4500#issuecomment-144328602\r\n\r\nFor reasonably small values of `n` and `m`, we should consider supporting\r\n`table.orderBy({index: ...}).skip(n).limit(m).changes()`\r\nand `table.orderBy({index: ...}).slice(n, m).changes()`.\r\n\r\nWe would just keep the full `n + m` first results in the in-memory queue and send changefeed notifications out only for changes in the lower n - n+m elements."},"comment":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/comments/144852475","html_url":"https://github.com/rethinkdb/rethinkdb/issues/4909#issuecomment-144852475","issue_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/4909","id":144852475,"user":{"login":"Fristi","id":141265,"avatar_url":"https://avatars.githubusercontent.com/u/141265?v=3","gravatar_id":"","url":"https://api.github.com/users/Fristi","html_url":"https://github.com/Fristi","followers_url":"https://api.github.com/users/Fristi/followers","following_url":"https://api.github.com/users/Fristi/following{/other_user}","gists_url":"https://api.github.com/users/Fristi/gists{/gist_id}","starred_url":"https://api.github.com/users/Fristi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Fristi/subscriptions","organizations_url":"https://api.github.com/users/Fristi/orgs","repos_url":"https://api.github.com/users/Fristi/repos","events_url":"https://api.github.com/users/Fristi/events{/privacy}","received_events_url":"https://api.github.com/users/Fristi/received_events","type":"User","site_admin":false},"created_at":"2015-10-01T21:14:12Z","updated_at":"2015-10-01T21:14:12Z","body":":+1: Looking forward to it!"}}