{"action":"created","issue":{"url":"https://api.github.com/repos/cyclus/cyclus/issues/1223","labels_url":"https://api.github.com/repos/cyclus/cyclus/issues/1223/labels{/name}","comments_url":"https://api.github.com/repos/cyclus/cyclus/issues/1223/comments","events_url":"https://api.github.com/repos/cyclus/cyclus/issues/1223/events","html_url":"https://github.com/cyclus/cyclus/issues/1223","id":122606311,"number":1223,"title":"Store inventories at run time","user":{"login":"scopatz","id":320553,"avatar_url":"https://avatars.githubusercontent.com/u/320553?v=3","gravatar_id":"","url":"https://api.github.com/users/scopatz","html_url":"https://github.com/scopatz","followers_url":"https://api.github.com/users/scopatz/followers","following_url":"https://api.github.com/users/scopatz/following{/other_user}","gists_url":"https://api.github.com/users/scopatz/gists{/gist_id}","starred_url":"https://api.github.com/users/scopatz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/scopatz/subscriptions","organizations_url":"https://api.github.com/users/scopatz/orgs","repos_url":"https://api.github.com/users/scopatz/repos","events_url":"https://api.github.com/users/scopatz/events{/privacy}","received_events_url":"https://api.github.com/users/scopatz/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/cyclus/cyclus/labels/Feature","name":"Feature","color":"02e10c"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/cyclus/cyclus/milestones/32","html_url":"https://github.com/cyclus/cyclus/milestones/v1.4","labels_url":"https://api.github.com/repos/cyclus/cyclus/milestones/32/labels","id":1082340,"number":32,"title":"v1.4","description":"Tentatively set to be due the week before ANS","creator":{"login":"gidden","id":1392657,"avatar_url":"https://avatars.githubusercontent.com/u/1392657?v=3","gravatar_id":"","url":"https://api.github.com/users/gidden","html_url":"https://github.com/gidden","followers_url":"https://api.github.com/users/gidden/followers","following_url":"https://api.github.com/users/gidden/following{/other_user}","gists_url":"https://api.github.com/users/gidden/gists{/gist_id}","starred_url":"https://api.github.com/users/gidden/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gidden/subscriptions","organizations_url":"https://api.github.com/users/gidden/orgs","repos_url":"https://api.github.com/users/gidden/repos","events_url":"https://api.github.com/users/gidden/events{/privacy}","received_events_url":"https://api.github.com/users/gidden/received_events","type":"User","site_admin":false},"open_issues":7,"closed_issues":31,"state":"open","created_at":"2015-04-24T14:11:32Z","updated_at":"2015-12-16T21:28:44Z","due_on":"2015-06-01T05:00:00Z","closed_at":null},"comments":4,"created_at":"2015-12-16T21:28:36Z","updated_at":"2015-12-16T23:28:54Z","closed_at":null,"body":"see https://groups.google.com/d/topic/cyclus-dev/RxiOb3jUSbM/discussion"},"comment":{"url":"https://api.github.com/repos/cyclus/cyclus/issues/comments/165285639","html_url":"https://github.com/cyclus/cyclus/issues/1223#issuecomment-165285639","issue_url":"https://api.github.com/repos/cyclus/cyclus/issues/1223","id":165285639,"user":{"login":"rwcarlsen","id":1351242,"avatar_url":"https://avatars.githubusercontent.com/u/1351242?v=3","gravatar_id":"","url":"https://api.github.com/users/rwcarlsen","html_url":"https://github.com/rwcarlsen","followers_url":"https://api.github.com/users/rwcarlsen/followers","following_url":"https://api.github.com/users/rwcarlsen/following{/other_user}","gists_url":"https://api.github.com/users/rwcarlsen/gists{/gist_id}","starred_url":"https://api.github.com/users/rwcarlsen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rwcarlsen/subscriptions","organizations_url":"https://api.github.com/users/rwcarlsen/orgs","repos_url":"https://api.github.com/users/rwcarlsen/repos","events_url":"https://api.github.com/users/rwcarlsen/events{/privacy}","received_events_url":"https://api.github.com/users/rwcarlsen/received_events","type":"User","site_admin":false},"created_at":"2015-12-16T23:28:54Z","updated_at":"2015-12-16T23:28:54Z","body":"The AgendId  must be stored even for the map<int,double> only method.  So\nthat is 24 b wasted vs 12 b required as opposed to 0 b wasted and 12 b\nrequired.  The space penalty for the schema I suggested is a constant\nmultiple on the size that would be required.  So 3 GB table my schema\nbecomes 1 GB table your method.  The penalty is always really close to 3X -\nregardless of how many facilities/nuclides (except for really small db's) -\nit never gets bigger.  I don't think the difference between those two sizes\nis worth the disbenefits I outlined.\n\nOn Wed, Dec 16, 2015 at 5:14 PM, Anthony Scopatz <notifications@github.com>\nwrote:\n\n> So back of the envelope: 28 b/nuc * 100 nuclide * 100 facilities * 1200\n> time steps / (1024*1024) is 320 Mb that is duplicated information. Go up to\n> 300 nuclides and you basically have an extra gig just in metadata.\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/cyclus/cyclus/issues/1223#issuecomment-165279379>.\n>\n"}}