Speeding up a 21h job to 8 minutes: a story of SQLAlchemy optimization

I have recently published an article on the Alan tech blog walking the reader through how we have reduced the runtime of our longest nightly job from 21 hours to about 8 minutes, by using simple profiling and SQLAlchemy optimizations.

Enjoy the reading!