{"action":"created","issue":{"url":"https://api.github.com/repos/adfinis-sygroup/finja/issues/1","labels_url":"https://api.github.com/repos/adfinis-sygroup/finja/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/adfinis-sygroup/finja/issues/1/comments","events_url":"https://api.github.com/repos/adfinis-sygroup/finja/issues/1/events","html_url":"https://github.com/adfinis-sygroup/finja/issues/1","id":127417894,"number":1,"title":"Search optimisations","user":{"login":"ganwell","id":1186530,"avatar_url":"https://avatars.githubusercontent.com/u/1186530?v=3","gravatar_id":"","url":"https://api.github.com/users/ganwell","html_url":"https://github.com/ganwell","followers_url":"https://api.github.com/users/ganwell/followers","following_url":"https://api.github.com/users/ganwell/following{/other_user}","gists_url":"https://api.github.com/users/ganwell/gists{/gist_id}","starred_url":"https://api.github.com/users/ganwell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ganwell/subscriptions","organizations_url":"https://api.github.com/users/ganwell/orgs","repos_url":"https://api.github.com/users/ganwell/repos","events_url":"https://api.github.com/users/ganwell/events{/privacy}","received_events_url":"https://api.github.com/users/ganwell/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-01-19T10:44:40Z","updated_at":"2016-01-19T12:11:12Z","closed_at":null,"body":"````finja readlines for in -> fast````\r\n\r\n````finja for in readlines -> slow````\r\n\r\nIt seems SQLite doesn't optimise join orders."},"comment":{"url":"https://api.github.com/repos/adfinis-sygroup/finja/issues/comments/172833966","html_url":"https://github.com/adfinis-sygroup/finja/issues/1#issuecomment-172833966","issue_url":"https://api.github.com/repos/adfinis-sygroup/finja/issues/1","id":172833966,"user":{"login":"winged","id":303759,"avatar_url":"https://avatars.githubusercontent.com/u/303759?v=3","gravatar_id":"","url":"https://api.github.com/users/winged","html_url":"https://github.com/winged","followers_url":"https://api.github.com/users/winged/followers","following_url":"https://api.github.com/users/winged/following{/other_user}","gists_url":"https://api.github.com/users/winged/gists{/gist_id}","starred_url":"https://api.github.com/users/winged/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/winged/subscriptions","organizations_url":"https://api.github.com/users/winged/orgs","repos_url":"https://api.github.com/users/winged/repos","events_url":"https://api.github.com/users/winged/events{/privacy}","received_events_url":"https://api.github.com/users/winged/received_events","type":"User","site_admin":false},"created_at":"2016-01-19T12:11:11Z","updated_at":"2016-01-19T12:11:11Z","body":"Seems so, yes... You could try getting a `count()` on all involved tokens first, and order the `JOIN` statements accordingly. Still possible that it could be slow if the statistics don't match the resulting files, but it should pose an improved overall performance (at the cost of some initial overhead to build the statistics)"}}