Some days I miss working on this site. I hold a lot of great memories of working with GoodnightPanda, crushing some insane bugs, completely changing the infrastructure, and building new features.
I remember one was introducing the caching subsystem. When the site only had like 50 accounts in it, the performance absolutely TANKED to where it would take sometimes 2 whole minutes to load your main timeline. Turns out the bottleneck was in the friends system itself, making several hundreds of queries to the database to get the latest friendship statuses from each profile.
I told Panda my plan to introduce Redis to cache a ton of the work being done every page request and he just told me to go for it. Couple days and several hundred lines of code later, timelines and pages were suddenly loading within milliseconds. We all waited for when the site would slow to a crawl again and.. it never happened. It’s still running on the same caching system I built all those years ago, and running smoooooooorh as glass as far as I can see.
I’ve got a few more stories like this one of anyone’s interested.
Until next time, cheers 馃嵒
Some days I miss working on this site. I hold a lot of great memories of working with GoodnightPanda, crushing some insane bugs, completely changing the infrastructure, and building new features.
I remember one was introducing the caching subsystem. When the site only had like 50 accounts in it, the performance absolutely TANKED to where it would take sometimes 2 whole minutes to load your main timeline. Turns out the bottleneck was in the friends system itself, making several hundreds of queries to the database to get the latest friendship statuses from each profile.
I told Panda my plan to introduce Redis to cache a ton of the work being done every page request and he just told me to go for it. Couple days and several hundred lines of code later, timelines and pages were suddenly loading within milliseconds. We all waited for when the site would slow to a crawl again and.. it never happened. It’s still running on the same caching system I built all those years ago, and running smoooooooorh as glass as far as I can see.
I’ve got a few more stories like this one of anyone’s interested.
Until next time, cheers 馃嵒
