{"action":"created","issue":{"url":"https://api.github.com/repos/Brewtarget/brewtarget/issues/309","repository_url":"https://api.github.com/repos/Brewtarget/brewtarget","labels_url":"https://api.github.com/repos/Brewtarget/brewtarget/issues/309/labels{/name}","comments_url":"https://api.github.com/repos/Brewtarget/brewtarget/issues/309/comments","events_url":"https://api.github.com/repos/Brewtarget/brewtarget/issues/309/events","html_url":"https://github.com/Brewtarget/brewtarget/issues/309","id":173363146,"number":309,"title":"Database performance","user":{"login":"mikfire","id":11296791,"avatar_url":"https://avatars.githubusercontent.com/u/11296791?v=3","gravatar_id":"","url":"https://api.github.com/users/mikfire","html_url":"https://github.com/mikfire","followers_url":"https://api.github.com/users/mikfire/followers","following_url":"https://api.github.com/users/mikfire/following{/other_user}","gists_url":"https://api.github.com/users/mikfire/gists{/gist_id}","starred_url":"https://api.github.com/users/mikfire/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mikfire/subscriptions","organizations_url":"https://api.github.com/users/mikfire/orgs","repos_url":"https://api.github.com/users/mikfire/repos","events_url":"https://api.github.com/users/mikfire/events{/privacy}","received_events_url":"https://api.github.com/users/mikfire/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-08-26T03:38:04Z","updated_at":"2016-08-29T23:38:57Z","closed_at":"2016-08-29T23:38:57Z","body":"# Database performance tuning\r\nWhen running against Postgresql, I noticed the initial load was slow. My rough count suggested 15 seconds from the time brewtarget started until it drew the screen.\r\n\r\n# tl;dr summary\r\nWith a bit of database sleuthing, I've been able to reduce the startup time using postgresql from 15 seconds to 2 seconds and the startup times with the sqlite database are averaging 0.4 seconds. In exchange, we have to accept some very limited caching.\r\n\r\nI would like to put these against the 2.4.0 branch because I think it is important. \r\n\r\n## Read the rest though\r\nThere's some interesting stuff in here, and some nice tools in postgresql that finally let me inspect what we are doing enough to find the problem and fix it. If I get nothing else from the postgresql change, this was worth it.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/Brewtarget/brewtarget/issues/comments/243290390","html_url":"https://github.com/Brewtarget/brewtarget/issues/309#issuecomment-243290390","issue_url":"https://api.github.com/repos/Brewtarget/brewtarget/issues/309","id":243290390,"user":{"login":"mikfire","id":11296791,"avatar_url":"https://avatars.githubusercontent.com/u/11296791?v=3","gravatar_id":"","url":"https://api.github.com/users/mikfire","html_url":"https://github.com/mikfire","followers_url":"https://api.github.com/users/mikfire/followers","following_url":"https://api.github.com/users/mikfire/following{/other_user}","gists_url":"https://api.github.com/users/mikfire/gists{/gist_id}","starred_url":"https://api.github.com/users/mikfire/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mikfire/subscriptions","organizations_url":"https://api.github.com/users/mikfire/orgs","repos_url":"https://api.github.com/users/mikfire/repos","events_url":"https://api.github.com/users/mikfire/events{/privacy}","received_events_url":"https://api.github.com/users/mikfire/received_events","type":"User","site_admin":false},"created_at":"2016-08-29T23:38:57Z","updated_at":"2016-08-29T23:38:57Z","body":"Closed with mr #310 "}}
{"actor":{"display_login":"mikfire"}}