{"action":"created","issue":{"url":"https://api.github.com/repos/Xyresic/Kaku/issues/1","repository_url":"https://api.github.com/repos/Xyresic/Kaku","labels_url":"https://api.github.com/repos/Xyresic/Kaku/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/Xyresic/Kaku/issues/1/comments","events_url":"https://api.github.com/repos/Xyresic/Kaku/issues/1/events","html_url":"https://github.com/Xyresic/Kaku/issues/1","id":192833956,"number":1,"title":"DB access is slow","user":{"login":"Xyresic","id":878158,"avatar_url":"https://avatars.githubusercontent.com/u/878158?v=3","gravatar_id":"","url":"https://api.github.com/users/Xyresic","html_url":"https://github.com/Xyresic","followers_url":"https://api.github.com/users/Xyresic/followers","following_url":"https://api.github.com/users/Xyresic/following{/other_user}","gists_url":"https://api.github.com/users/Xyresic/gists{/gist_id}","starred_url":"https://api.github.com/users/Xyresic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Xyresic/subscriptions","organizations_url":"https://api.github.com/users/Xyresic/orgs","repos_url":"https://api.github.com/users/Xyresic/repos","events_url":"https://api.github.com/users/Xyresic/events{/privacy}","received_events_url":"https://api.github.com/users/Xyresic/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-12-01T12:30:41Z","updated_at":"2016-12-02T03:29:24Z","closed_at":"2016-12-02T03:29:24Z","body":"Might be able to use native SQLite to speed it up? Some untested SQLite code:\r\n\r\n```sql\r\nSELECT result.fkEntry_id, result.kanji_id, result.kanji, result.reading_id, result.reading, result.meaning_id, result.meaninggloss_id, result.gloss, result.readingrestriction_id, result.readingRestriction, meaningkanjirestriction.id AS meaningkanjirestriction_id, meaningkanjirestriction.kanjiRestriction\r\nFROM (SELECT result.fkEntry_id, result.kanji_id, result.kanji, result.reading_id, result.reading, result.meaning_id, result.meaninggloss_id, result.gloss, readingrestriction.id AS readingrestriction_id, readingrestriction.readingRestriction\r\n      FROM (SELECT result.fkEntry_id, result.kanji_id, result.kanji, result.reading_id, result.reading, result.meaning_id, meaninggloss.id AS meaninggloss_id, meaninggloss.gloss\r\n            FROM (SELECT result.fkEntry_id, result.kanji_id, result.kanji, reading.id AS reading_id, reading.reading, result.meaning_id\r\n                  FROM (SELECT kanji.fkEntry_id, kanji.id AS kanji_id, kanji.kanji, meaning.id AS meaning_id\r\n                        FROM kanji\r\n                        INNER JOIN meaning ON kanji.fkEntry_id = meaning.fkEntry_id\r\n                        WHERE kanji.kanji LIKE '%') AS result\r\n                  INNER JOIN reading ON reading.fkEntry_id = result.fkEntry_id) AS result\r\n            INNER JOIN meaninggloss ON result.meaning_id = meaninggloss.fkMeaning_id\r\n            GROUP BY meaninggloss_id) AS result\r\n      LEFT JOIN readingrestriction ON result.reading_id = readingrestriction.fkReading_id) AS result\r\nLEFT JOIN meaningkanjirestriction ON result.meaning_id = meaningkanjirestriction.fkMeaning_id\r\nORDER BY meaning_id\r\n```"},"comment":{"url":"https://api.github.com/repos/Xyresic/Kaku/issues/comments/264364627","html_url":"https://github.com/Xyresic/Kaku/issues/1#issuecomment-264364627","issue_url":"https://api.github.com/repos/Xyresic/Kaku/issues/1","id":264364627,"user":{"login":"Xyresic","id":878158,"avatar_url":"https://avatars.githubusercontent.com/u/878158?v=3","gravatar_id":"","url":"https://api.github.com/users/Xyresic","html_url":"https://github.com/Xyresic","followers_url":"https://api.github.com/users/Xyresic/followers","following_url":"https://api.github.com/users/Xyresic/following{/other_user}","gists_url":"https://api.github.com/users/Xyresic/gists{/gist_id}","starred_url":"https://api.github.com/users/Xyresic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Xyresic/subscriptions","organizations_url":"https://api.github.com/users/Xyresic/orgs","repos_url":"https://api.github.com/users/Xyresic/repos","events_url":"https://api.github.com/users/Xyresic/events{/privacy}","received_events_url":"https://api.github.com/users/Xyresic/received_events","type":"User","site_admin":false},"created_at":"2016-12-02T03:29:24Z","updated_at":"2016-12-02T03:29:24Z","body":"Fixed. Put frequently accessed data into a single table for faster access. Searches are taking ~250ms on average now."}}
{"actor":{"display_login":"Xyresic"}}