{"action":"opened","issue":{"url":"https://api.github.com/repos/kdeloach/querycsv-redux/issues/11","labels_url":"https://api.github.com/repos/kdeloach/querycsv-redux/issues/11/labels{/name}","comments_url":"https://api.github.com/repos/kdeloach/querycsv-redux/issues/11/comments","events_url":"https://api.github.com/repos/kdeloach/querycsv-redux/issues/11/events","html_url":"https://github.com/kdeloach/querycsv-redux/issues/11","id":101478388,"number":11,"title":"SqlLite lifecycle","user":{"login":"steveoh","id":325813,"avatar_url":"https://avatars.githubusercontent.com/u/325813?v=3","gravatar_id":"","url":"https://api.github.com/users/steveoh","html_url":"https://github.com/steveoh","followers_url":"https://api.github.com/users/steveoh/followers","following_url":"https://api.github.com/users/steveoh/following{/other_user}","gists_url":"https://api.github.com/users/steveoh/gists{/gist_id}","starred_url":"https://api.github.com/users/steveoh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/steveoh/subscriptions","organizations_url":"https://api.github.com/users/steveoh/orgs","repos_url":"https://api.github.com/users/steveoh/repos","events_url":"https://api.github.com/users/steveoh/events{/privacy}","received_events_url":"https://api.github.com/users/steveoh/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-08-17T18:13:09Z","updated_at":"2015-08-17T18:13:09Z","closed_at":null,"body":"What is the lifecycle of the sqlite db's when querying for a value in a file? I've noticed that perf is pretty bad on some larger db's and it made me wonder, since we are querying the same file many times, if it is building the db on every query. "}}