User avatar
zotan (.NET edition) shrimp2 @zotan@next.e2net.social
2y
Massively improved overall endpoint performance today by optimizing queries. see attachment (request runtime in milliseconds, % = improvement, 100% = unchanged)
1
1
4
0
User avatar
zotan (.NET edition) shrimp2 @zotan@next.e2net.social
2y
the "main" query for each of these improved by ~3-10x.
1
1
1
0
User avatar
zotan (.NET edition) shrimp2 @zotan@next.e2net.social
2y
the most extreme examples are the home tl query (~50ms -> ~9ms) and the conversations query (~35ms -> ~5ms)
1
1
1
0
User avatar
zotan (.NET edition) shrimp2 @zotan@next.e2net.social
2y
All queries I analyzed are now as optimized as they can be. The remaining query runtime is mostly planning time, the execution time is usually 3ms or less.
1
1
1
0
User avatar
zotan (.NET edition) shrimp2 @zotan@next.e2net.social
2y
If there are more gains to be had I don't (yet) know how to achieve them. We're now significantly faster at being mastodon than mastodon itself is, with no caching layers.
1
1
5
0
User avatar
zotan (.NET edition) shrimp2 @zotan@next.e2net.social
2y
With that I declare this performance profiling pass complete. I'll probably do another one in the stable development cycle, but that's months away.
0
0
1
0