How we optimized Python API server code 100x

Some of the tricks we used to speed up calls to our analytics API written in Python: played with asyncio, messed with SQLAlchemy, hacked deep in asyncpg, rewrote parts in Cython, found better data structures, replaced some pandas with pure numpy....