{"action":"created","issue":{"url":"https://api.github.com/repos/darktable-org/darktable/issues/973","labels_url":"https://api.github.com/repos/darktable-org/darktable/issues/973/labels{/name}","comments_url":"https://api.github.com/repos/darktable-org/darktable/issues/973/comments","events_url":"https://api.github.com/repos/darktable-org/darktable/issues/973/events","html_url":"https://github.com/darktable-org/darktable/pull/973","id":102576559,"number":973,"title":"Preload images in the full-size preview and simplify SQL a bit","user":{"login":"jktjkt","id":2631925,"avatar_url":"https://avatars.githubusercontent.com/u/2631925?v=3","gravatar_id":"","url":"https://api.github.com/users/jktjkt","html_url":"https://github.com/jktjkt","followers_url":"https://api.github.com/users/jktjkt/followers","following_url":"https://api.github.com/users/jktjkt/following{/other_user}","gists_url":"https://api.github.com/users/jktjkt/gists{/gist_id}","starred_url":"https://api.github.com/users/jktjkt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jktjkt/subscriptions","organizations_url":"https://api.github.com/users/jktjkt/orgs","repos_url":"https://api.github.com/users/jktjkt/repos","events_url":"https://api.github.com/users/jktjkt/events{/privacy}","received_events_url":"https://api.github.com/users/jktjkt/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-08-23T00:20:05Z","updated_at":"2015-08-26T09:43:36Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/darktable-org/darktable/pulls/973","html_url":"https://github.com/darktable-org/darktable/pull/973","diff_url":"https://github.com/darktable-org/darktable/pull/973.diff","patch_url":"https://github.com/darktable-org/darktable/pull/973.patch"},"body":"The previous version of these SQL statements were a result of a few\r\nyears of incremental changes; under certain circumstances it was doing a\r\nsubquery and joining the result back with the original table. This\r\nchange simplifies the logic a bit -- the patch is best viewed when\r\nignoring indentation.\r\n\r\nThe real motivation was however speculative preload of a couple of next\r\nimages. Loading them in background cuts the latency when the user\r\nnavigates images that have expensive IOPs in theit history stacks. See\r\nhttp://thread.gmane.org/gmane.comp.graphics.darktable.user/7832 for\r\ndetails."},"comment":{"url":"https://api.github.com/repos/darktable-org/darktable/issues/comments/134925754","html_url":"https://github.com/darktable-org/darktable/pull/973#issuecomment-134925754","issue_url":"https://api.github.com/repos/darktable-org/darktable/issues/973","id":134925754,"user":{"login":"jktjkt","id":2631925,"avatar_url":"https://avatars.githubusercontent.com/u/2631925?v=3","gravatar_id":"","url":"https://api.github.com/users/jktjkt","html_url":"https://github.com/jktjkt","followers_url":"https://api.github.com/users/jktjkt/followers","following_url":"https://api.github.com/users/jktjkt/following{/other_user}","gists_url":"https://api.github.com/users/jktjkt/gists{/gist_id}","starred_url":"https://api.github.com/users/jktjkt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jktjkt/subscriptions","organizations_url":"https://api.github.com/users/jktjkt/orgs","repos_url":"https://api.github.com/users/jktjkt/repos","events_url":"https://api.github.com/users/jktjkt/events{/privacy}","received_events_url":"https://api.github.com/users/jktjkt/received_events","type":"User","site_admin":false},"created_at":"2015-08-26T09:43:36Z","updated_at":"2015-08-26T09:43:36Z","body":"Please see patch v2 (not sure if GitHub liked my force-push)."}}