{"action":"closed","issue":{"url":"https://api.github.com/repos/khartec/waltz/issues/793","repository_url":"https://api.github.com/repos/khartec/waltz","labels_url":"https://api.github.com/repos/khartec/waltz/issues/793/labels{/name}","comments_url":"https://api.github.com/repos/khartec/waltz/issues/793/comments","events_url":"https://api.github.com/repos/khartec/waltz/issues/793/events","html_url":"https://github.com/khartec/waltz/issues/793","id":184286802,"number":793,"title":"SQL Server: Improve performance of fetching historic entity stat values","user":{"login":"rovats","id":15289335,"avatar_url":"https://avatars.githubusercontent.com/u/15289335?v=3","gravatar_id":"","url":"https://api.github.com/users/rovats","html_url":"https://github.com/rovats","followers_url":"https://api.github.com/users/rovats/followers","following_url":"https://api.github.com/users/rovats/following{/other_user}","gists_url":"https://api.github.com/users/rovats/gists{/gist_id}","starred_url":"https://api.github.com/users/rovats/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rovats/subscriptions","organizations_url":"https://api.github.com/users/rovats/orgs","repos_url":"https://api.github.com/users/rovats/repos","events_url":"https://api.github.com/users/rovats/events{/privacy}","received_events_url":"https://api.github.com/users/rovats/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/khartec/waltz/labels/fixed%20(test%20&%20close)","name":"fixed (test & close)","color":"5319e7"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/khartec/waltz/milestones/14","html_url":"https://github.com/khartec/waltz/milestones/0.9.0","labels_url":"https://api.github.com/repos/khartec/waltz/milestones/14/labels","id":2062211,"number":14,"title":"0.9.0","description":"","creator":{"login":"davidwatkins73","id":576829,"avatar_url":"https://avatars.githubusercontent.com/u/576829?v=3","gravatar_id":"","url":"https://api.github.com/users/davidwatkins73","html_url":"https://github.com/davidwatkins73","followers_url":"https://api.github.com/users/davidwatkins73/followers","following_url":"https://api.github.com/users/davidwatkins73/following{/other_user}","gists_url":"https://api.github.com/users/davidwatkins73/gists{/gist_id}","starred_url":"https://api.github.com/users/davidwatkins73/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidwatkins73/subscriptions","organizations_url":"https://api.github.com/users/davidwatkins73/orgs","repos_url":"https://api.github.com/users/davidwatkins73/repos","events_url":"https://api.github.com/users/davidwatkins73/events{/privacy}","received_events_url":"https://api.github.com/users/davidwatkins73/received_events","type":"User","site_admin":false},"open_issues":10,"closed_issues":33,"state":"open","created_at":"2016-10-11T13:23:28Z","updated_at":"2016-10-27T08:18:39Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2016-10-20T17:06:26Z","updated_at":"2016-10-27T08:18:39Z","closed_at":"2016-10-27T08:18:39Z","body":"The following condition generated by jOOQ causes the query to run very slowly on SQL Server:\r\n\r\n`and cast([esv].[created_at] as date) > dateadd(day, -(31), convert(date, current_timestamp)))`\r\n\r\nbut the following are really quick, so the `convert` function is killing performance:\r\n\r\n`and cast([esv].[created_at] as date) > getdate() - 31`\r\n`and cast([esv].[created_at] as date) > dateadd(day, -(31), current_timestamp)`\r\n"}}
{"actor":{"display_login":"davidwatkins73"}}