{"action":"created","issue":{"url":"https://api.github.com/repos/ManageIQ/manageiq/issues/14674","repository_url":"https://api.github.com/repos/ManageIQ/manageiq","labels_url":"https://api.github.com/repos/ManageIQ/manageiq/issues/14674/labels{/name}","comments_url":"https://api.github.com/repos/ManageIQ/manageiq/issues/14674/comments","events_url":"https://api.github.com/repos/ManageIQ/manageiq/issues/14674/events","html_url":"https://github.com/ManageIQ/manageiq/pull/14674","id":219914088,"number":14674,"title":"[EUWE] Optimize number of transactions sent in refresh euwe","user":{"login":"Ladas","id":1737058,"avatar_url":"https://avatars3.githubusercontent.com/u/1737058?v=3","gravatar_id":"","url":"https://api.github.com/users/Ladas","html_url":"https://github.com/Ladas","followers_url":"https://api.github.com/users/Ladas/followers","following_url":"https://api.github.com/users/Ladas/following{/other_user}","gists_url":"https://api.github.com/users/Ladas/gists{/gist_id}","starred_url":"https://api.github.com/users/Ladas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ladas/subscriptions","organizations_url":"https://api.github.com/users/Ladas/orgs","repos_url":"https://api.github.com/users/Ladas/repos","events_url":"https://api.github.com/users/Ladas/events{/privacy}","received_events_url":"https://api.github.com/users/Ladas/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-04-06T14:17:31Z","updated_at":"2017-04-06T14:29:19Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/ManageIQ/manageiq/pulls/14674","html_url":"https://github.com/ManageIQ/manageiq/pull/14674","diff_url":"https://github.com/ManageIQ/manageiq/pull/14674.diff","patch_url":"https://github.com/ManageIQ/manageiq/pull/14674.patch"},"body":"Not clean cherry-pick of: https://github.com/ManageIQ/manageiq/pull/14670\r\n\r\nDo not do a blank transaction if the record hasn't changed, becaiuse it causes extra 2 queries, transaction BEGIN and END. And wrap updating&deleting in 1 big transaction. Doing transaction per update is expensive, since we do BEGIN, update, END, so 3 queries per one updateand the same for delete. With remote DB, this will add a lot of processing time."},"comment":{"url":"https://api.github.com/repos/ManageIQ/manageiq/issues/comments/292192015","html_url":"https://github.com/ManageIQ/manageiq/pull/14674#issuecomment-292192015","issue_url":"https://api.github.com/repos/ManageIQ/manageiq/issues/14674","id":292192015,"user":{"login":"miq-bot","id":7806257,"avatar_url":"https://avatars2.githubusercontent.com/u/7806257?v=3","gravatar_id":"","url":"https://api.github.com/users/miq-bot","html_url":"https://github.com/miq-bot","followers_url":"https://api.github.com/users/miq-bot/followers","following_url":"https://api.github.com/users/miq-bot/following{/other_user}","gists_url":"https://api.github.com/users/miq-bot/gists{/gist_id}","starred_url":"https://api.github.com/users/miq-bot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/miq-bot/subscriptions","organizations_url":"https://api.github.com/users/miq-bot/orgs","repos_url":"https://api.github.com/users/miq-bot/repos","events_url":"https://api.github.com/users/miq-bot/events{/privacy}","received_events_url":"https://api.github.com/users/miq-bot/received_events","type":"User","site_admin":false},"created_at":"2017-04-06T14:29:19Z","updated_at":"2017-04-06T14:29:19Z","body":"<rubocop />Checked commits https://github.com/Ladas/manageiq/compare/2509b6141c32a82b433d93140e244782265562b6~...2cfc9d1150fa7a4b65355c84a57c6cca6e6f2e4c with ruby 2.2.6, rubocop 0.47.1, and haml-lint 0.20.0\n1 file checked, 0 offenses detected\nEverything looks good. :cake:\n"}}
{"actor":{"display_login":"miq-bot"}}