Earlier this year I presented at PyCon 2023 in Salt Lake City, UT on the topic of "Efficient Cross-Server Data Joins on Slow Networks with Python". You can watch the presentation on YouTube:
Watch this presentation on PyCon's YouTube channel.
Slides from the session can be found https://github.com/bertwagner/Presentations/tree/master/crosstream.
The crosstream Python package mentioned can be found at: https://github.com/bertwagner/crosstream.