{"action":"created","issue":{"url":"https://api.github.com/repos/pacificclimate/climate-explorer-backend/issues/9","labels_url":"https://api.github.com/repos/pacificclimate/climate-explorer-backend/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/pacificclimate/climate-explorer-backend/issues/9/comments","events_url":"https://api.github.com/repos/pacificclimate/climate-explorer-backend/issues/9/events","html_url":"https://github.com/pacificclimate/climate-explorer-backend/issues/9","id":125998827,"number":9,"title":"`multimeta` API call is too slow for moderate number of files","user":{"login":"jameshiebert","id":3904316,"avatar_url":"https://avatars.githubusercontent.com/u/3904316?v=3","gravatar_id":"","url":"https://api.github.com/users/jameshiebert","html_url":"https://github.com/jameshiebert","followers_url":"https://api.github.com/users/jameshiebert/followers","following_url":"https://api.github.com/users/jameshiebert/following{/other_user}","gists_url":"https://api.github.com/users/jameshiebert/gists{/gist_id}","starred_url":"https://api.github.com/users/jameshiebert/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jameshiebert/subscriptions","organizations_url":"https://api.github.com/users/jameshiebert/orgs","repos_url":"https://api.github.com/users/jameshiebert/repos","events_url":"https://api.github.com/users/jameshiebert/events{/privacy}","received_events_url":"https://api.github.com/users/jameshiebert/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pacificclimate/climate-explorer-backend/labels/performance","name":"performance","color":"bfd4f2"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-01-11T17:46:20Z","updated_at":"2016-01-20T16:20:13Z","closed_at":null,"body":"I have an sqlite database which has indexed 660 ClimDEX files, and the multimeta API call takes 30 seconds to return.\r\n\r\n```bash\r\n$ time curl -s http://localhost:9000/api/multimeta\r\nreal\t0m29.051s\r\nuser\t0m0.016s\r\nsys\t0m0.000s\r\n```\r\n\r\nPostgreSQL may be more reasonable, but if not, we'll need to do some query optimization for the multimeta call."},"comment":{"url":"https://api.github.com/repos/pacificclimate/climate-explorer-backend/issues/comments/173257130","html_url":"https://github.com/pacificclimate/climate-explorer-backend/issues/9#issuecomment-173257130","issue_url":"https://api.github.com/repos/pacificclimate/climate-explorer-backend/issues/9","id":173257130,"user":{"login":"jameshiebert","id":3904316,"avatar_url":"https://avatars.githubusercontent.com/u/3904316?v=3","gravatar_id":"","url":"https://api.github.com/users/jameshiebert","html_url":"https://github.com/jameshiebert","followers_url":"https://api.github.com/users/jameshiebert/followers","following_url":"https://api.github.com/users/jameshiebert/following{/other_user}","gists_url":"https://api.github.com/users/jameshiebert/gists{/gist_id}","starred_url":"https://api.github.com/users/jameshiebert/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jameshiebert/subscriptions","organizations_url":"https://api.github.com/users/jameshiebert/orgs","repos_url":"https://api.github.com/users/jameshiebert/repos","events_url":"https://api.github.com/users/jameshiebert/events{/privacy}","received_events_url":"https://api.github.com/users/jameshiebert/received_events","type":"User","site_admin":false},"created_at":"2016-01-20T16:20:13Z","updated_at":"2016-01-20T16:20:13Z","body":"This was a good stop-gap measure for the demo. However, the performance problem here ultimately still exists and is going to prevent the backend from scaling to larger number of datasets."}}