{"action":"created","issue":{"url":"https://api.github.com/repos/voat/voat/issues/446","labels_url":"https://api.github.com/repos/voat/voat/issues/446/labels{/name}","comments_url":"https://api.github.com/repos/voat/voat/issues/446/comments","events_url":"https://api.github.com/repos/voat/voat/issues/446/events","html_url":"https://github.com/voat/voat/issues/446","id":87119122,"number":446,"title":"Scalability super fun time","user":{"login":"Aaronontheweb","id":326939,"avatar_url":"https://avatars.githubusercontent.com/u/326939?v=3","gravatar_id":"","url":"https://api.github.com/users/Aaronontheweb","html_url":"https://github.com/Aaronontheweb","followers_url":"https://api.github.com/users/Aaronontheweb/followers","following_url":"https://api.github.com/users/Aaronontheweb/following{/other_user}","gists_url":"https://api.github.com/users/Aaronontheweb/gists{/gist_id}","starred_url":"https://api.github.com/users/Aaronontheweb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Aaronontheweb/subscriptions","organizations_url":"https://api.github.com/users/Aaronontheweb/orgs","repos_url":"https://api.github.com/users/Aaronontheweb/repos","events_url":"https://api.github.com/users/Aaronontheweb/events{/privacy}","received_events_url":"https://api.github.com/users/Aaronontheweb/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":19,"created_at":"2015-06-10T21:50:30Z","updated_at":"2015-06-13T05:56:41Z","closed_at":null,"body":"So, some of the stuff brought up in #445 were fair points, although delivered in a way that didn't occur for me as \"constructive.\" Given that the site is 503-ing a bunch right now, it's probably a good time to talk about scalability.\r\n\r\nFirst, and most importantly: @PuttItOut and @voat - can you guys actually afford to run more servers? If not, then we should talk about doing something to help with that.\r\n\r\nSecond: are you open to having me and others help on scalability issues? Some of the stuff that we might propose may involve expensive stuff like \"migrating comments and votes off of SQL Server\""},"comment":{"url":"https://api.github.com/repos/voat/voat/issues/comments/111677816","html_url":"https://github.com/voat/voat/issues/446#issuecomment-111677816","issue_url":"https://api.github.com/repos/voat/voat/issues/446","id":111677816,"user":{"login":"ryanelian","id":8892187,"avatar_url":"https://avatars.githubusercontent.com/u/8892187?v=3","gravatar_id":"","url":"https://api.github.com/users/ryanelian","html_url":"https://github.com/ryanelian","followers_url":"https://api.github.com/users/ryanelian/followers","following_url":"https://api.github.com/users/ryanelian/following{/other_user}","gists_url":"https://api.github.com/users/ryanelian/gists{/gist_id}","starred_url":"https://api.github.com/users/ryanelian/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ryanelian/subscriptions","organizations_url":"https://api.github.com/users/ryanelian/orgs","repos_url":"https://api.github.com/users/ryanelian/repos","events_url":"https://api.github.com/users/ryanelian/events{/privacy}","received_events_url":"https://api.github.com/users/ryanelian/received_events","type":"User","site_admin":false},"created_at":"2015-06-13T05:56:41Z","updated_at":"2015-06-13T05:56:41Z","body":"http://stackexchange.com/performance\r\n\r\nWith 27 servers, their peak is only 10%. I think they can survive with much less than 27 servers.\r\n\r\nWe might be able to offload the searching feature of the voat using Google custom search instead. And yes, we should cache.\r\n\r\nWe can live with EF for now. Contrary to popular beliefs, it's actually very fast if you write your EF optimally (mostly has something to do with avoiding Lazy Loading and/or turning off change tracker / manually detecting changes)."}}