-
Most solo founder work is boring to share on Twitter. But I still enjoy it. Today I'm hunting down bad performance in my app. Read on if you like some behind-the-scenes ...Permalink On twitter.com
♻️ 3 Retweets ❤️ 50 Favorites Mood -1 🙁
-
So I'm looking at the P95 response times of my server. P95 excludes the worst 5% and shows how long most users have to stare at the loading spinner. Spoiler: way too long! 300ms would be OK ~1s is not OKPermalink On twitter.com
-
I highlighted the worst offenders here. Sadly, these are the most important functions of my tool. So that's not good!On twitter.com
-
Investigating further it seems that one of my two servers is specifically affected.Permalink On twitter.com
-
It's the EU server. Makes sense, because the database is in the US. So for every DB lookup the EU has to make costly round-trips across the big pond.Permalink On twitter.com
-
So I'm forensically checking the code to see where I can avoid unnecessary DB operations. I already found a few places where I could avoid them and others were they can be performed asynchronously. Let's see if the stats improve after todays update 😃Permalink On twitter.com