{"action":"created","issue":{"url":"https://api.github.com/repos/c4fcm/DataBasic/issues/209","repository_url":"https://api.github.com/repos/c4fcm/DataBasic","labels_url":"https://api.github.com/repos/c4fcm/DataBasic/issues/209/labels{/name}","comments_url":"https://api.github.com/repos/c4fcm/DataBasic/issues/209/comments","events_url":"https://api.github.com/repos/c4fcm/DataBasic/issues/209/events","html_url":"https://github.com/c4fcm/DataBasic/issues/209","id":153076310,"number":209,"title":"Performance issues in workshop setting","user":{"login":"kanarinka","id":1102550,"avatar_url":"https://avatars.githubusercontent.com/u/1102550?v=3","gravatar_id":"","url":"https://api.github.com/users/kanarinka","html_url":"https://github.com/kanarinka","followers_url":"https://api.github.com/users/kanarinka/followers","following_url":"https://api.github.com/users/kanarinka/following{/other_user}","gists_url":"https://api.github.com/users/kanarinka/gists{/gist_id}","starred_url":"https://api.github.com/users/kanarinka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kanarinka/subscriptions","organizations_url":"https://api.github.com/users/kanarinka/orgs","repos_url":"https://api.github.com/users/kanarinka/repos","events_url":"https://api.github.com/users/kanarinka/events{/privacy}","received_events_url":"https://api.github.com/users/kanarinka/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/c4fcm/DataBasic/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/c4fcm/DataBasic/labels/WTFcsv","name":"WTFcsv","color":"fbca04"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/c4fcm/DataBasic/milestones/8","html_url":"https://github.com/c4fcm/DataBasic/milestones/v1.3%20-%20Next%20Big%20Release","labels_url":"https://api.github.com/repos/c4fcm/DataBasic/milestones/8/labels","id":1605665,"number":8,"title":"v1.3 - Next Big Release","description":"","creator":{"login":"rahulbot","id":673178,"avatar_url":"https://avatars.githubusercontent.com/u/673178?v=3","gravatar_id":"","url":"https://api.github.com/users/rahulbot","html_url":"https://github.com/rahulbot","followers_url":"https://api.github.com/users/rahulbot/followers","following_url":"https://api.github.com/users/rahulbot/following{/other_user}","gists_url":"https://api.github.com/users/rahulbot/gists{/gist_id}","starred_url":"https://api.github.com/users/rahulbot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rahulbot/subscriptions","organizations_url":"https://api.github.com/users/rahulbot/orgs","repos_url":"https://api.github.com/users/rahulbot/repos","events_url":"https://api.github.com/users/rahulbot/events{/privacy}","received_events_url":"https://api.github.com/users/rahulbot/received_events","type":"User","site_admin":false},"open_issues":7,"closed_issues":0,"state":"open","created_at":"2016-02-25T16:53:57Z","updated_at":"2016-05-04T17:57:20Z","due_on":"2016-03-30T04:00:00Z","closed_at":null},"comments":2,"created_at":"2016-05-04T17:57:20Z","updated_at":"2016-05-04T20:32:53Z","closed_at":null,"body":"I did a DB workshop this morning with around 15-20 people connected simultaneously. All fine for WordCounter and SameDiff, however when we did the WTFcsv activity there were huge performance issues. They were not just the WTFcsv tool but the whole databasic site which seemed to go down and then come back up. We should look at server logs for ~11:30am EST on 5/4/2016 to try to figure out what went down. When people would type in the main DB url it would simply take forever just to load the homepage and sometimes timeout. "},"comment":{"url":"https://api.github.com/repos/c4fcm/DataBasic/issues/comments/216994000","html_url":"https://github.com/c4fcm/DataBasic/issues/209#issuecomment-216994000","issue_url":"https://api.github.com/repos/c4fcm/DataBasic/issues/209","id":216994000,"user":{"login":"kanarinka","id":1102550,"avatar_url":"https://avatars.githubusercontent.com/u/1102550?v=3","gravatar_id":"","url":"https://api.github.com/users/kanarinka","html_url":"https://github.com/kanarinka","followers_url":"https://api.github.com/users/kanarinka/followers","following_url":"https://api.github.com/users/kanarinka/following{/other_user}","gists_url":"https://api.github.com/users/kanarinka/gists{/gist_id}","starred_url":"https://api.github.com/users/kanarinka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kanarinka/subscriptions","organizations_url":"https://api.github.com/users/kanarinka/orgs","repos_url":"https://api.github.com/users/kanarinka/repos","events_url":"https://api.github.com/users/kanarinka/events{/privacy}","received_events_url":"https://api.github.com/users/kanarinka/received_events","type":"User","site_admin":false},"created_at":"2016-05-04T20:32:53Z","updated_at":"2016-05-04T20:32:53Z","body":"Whoa so weird. They were using custom data sets that I sourced for each\ncity, but all under 10MB - the largest is 6MB. You can see them all here:\nhttps://www.dropbox.com/sh/y055540sny9x88q/AAAVyMd5nPc7lVvZA4OrXQG4a?dl=0\n\nI think I was the only one using it last night at 10:30. I was trying to\nfind various data sets that were appropriate for each city's project. I may\nhave inadvertantly uploaded some giant file but it should spit out an error\nif over 10MB, not process the file, right? Or does the giant file somehow\nstill get processed and stick around in server memory?\n\nOn Wed, May 4, 2016 at 4:08 PM rahulbot <notifications@github.com> wrote:\n\n> Weird. Metrics attached - looks like memory filled up :-(\n> They were using sample date? I'm curious what happened around 10:30pm last\n> night that borked the memory so hard.\n>\n> [image: databasic-prod_ _metrics___heroku]\n> <https://cloud.githubusercontent.com/assets/673178/15027515/384995a0-1212-11e6-97eb-5ede81711b74.png>\n>\n> —\n> You are receiving this because you authored the thread.\n> Reply to this email directly or view it on GitHub\n> <https://github.com/c4fcm/DataBasic/issues/209#issuecomment-216986090>\n>\n"}}