{"action":"created","issue":{"url":"https://api.github.com/repos/MIT-LCP/mimic-code/issues/151","repository_url":"https://api.github.com/repos/MIT-LCP/mimic-code","labels_url":"https://api.github.com/repos/MIT-LCP/mimic-code/issues/151/labels{/name}","comments_url":"https://api.github.com/repos/MIT-LCP/mimic-code/issues/151/comments","events_url":"https://api.github.com/repos/MIT-LCP/mimic-code/issues/151/events","html_url":"https://github.com/MIT-LCP/mimic-code/issues/151","id":189371769,"number":151,"title":"MIMIC-III database set up issues","user":{"login":"aditya-joshi-hl7","id":23476677,"avatar_url":"https://avatars.githubusercontent.com/u/23476677?v=3","gravatar_id":"","url":"https://api.github.com/users/aditya-joshi-hl7","html_url":"https://github.com/aditya-joshi-hl7","followers_url":"https://api.github.com/users/aditya-joshi-hl7/followers","following_url":"https://api.github.com/users/aditya-joshi-hl7/following{/other_user}","gists_url":"https://api.github.com/users/aditya-joshi-hl7/gists{/gist_id}","starred_url":"https://api.github.com/users/aditya-joshi-hl7/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aditya-joshi-hl7/subscriptions","organizations_url":"https://api.github.com/users/aditya-joshi-hl7/orgs","repos_url":"https://api.github.com/users/aditya-joshi-hl7/repos","events_url":"https://api.github.com/users/aditya-joshi-hl7/events{/privacy}","received_events_url":"https://api.github.com/users/aditya-joshi-hl7/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-11-15T11:52:36Z","updated_at":"2016-11-15T16:25:30Z","closed_at":null,"body":"Hello,\r\n\r\nI am setting up MIMIC-III database by uploading all 26 csv files in MySql database. After uploading few of the tables, we realize that it is huge data and probably storing in local system won’t be feasible. Also, simple queries like count(*) taking around an hour for big tables (with csv size greater than 500MB). It seems that roughly there are 300+ million records in entire MIMIC-III tables. \r\n\r\nCould you please help in letting us know what is _minimum or sufficient system requirements_ in order to upload and play with MIMIC data. We want to know about **_hardware requirements to hold this data and to query efficiently_**. It would be great help as we would be then able to setup things quickly and it will help us in our research work. As of now we are using MySql db to store and query this data. \r\n\r\nRegards,\r\nAditya Joshi\r\nSenior Team Lead- Digital Health \r\n"},"comment":{"url":"https://api.github.com/repos/MIT-LCP/mimic-code/issues/comments/260689680","html_url":"https://github.com/MIT-LCP/mimic-code/issues/151#issuecomment-260689680","issue_url":"https://api.github.com/repos/MIT-LCP/mimic-code/issues/151","id":260689680,"user":{"login":"tompollard","id":822601,"avatar_url":"https://avatars.githubusercontent.com/u/822601?v=3","gravatar_id":"","url":"https://api.github.com/users/tompollard","html_url":"https://github.com/tompollard","followers_url":"https://api.github.com/users/tompollard/followers","following_url":"https://api.github.com/users/tompollard/following{/other_user}","gists_url":"https://api.github.com/users/tompollard/gists{/gist_id}","starred_url":"https://api.github.com/users/tompollard/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tompollard/subscriptions","organizations_url":"https://api.github.com/users/tompollard/orgs","repos_url":"https://api.github.com/users/tompollard/repos","events_url":"https://api.github.com/users/tompollard/events{/privacy}","received_events_url":"https://api.github.com/users/tompollard/received_events","type":"User","site_admin":false},"created_at":"2016-11-15T16:25:30Z","updated_at":"2016-11-15T16:25:30Z","body":"Hi Aditya, you shouldn't need a super high performance computer to install MIMIC. A system with a recent CPU, 8GB RAM, and 80GB free disk space (preferably solid state) should be fine. I run MIMIC in Postgres 9.5 on a 2 year old MacBook Pro, which has I5 CPU, 8GB of RAM, solid state drive. "}}
{"actor":{"display_login":"tompollard"}}