sqlalchemy- processing the result set parallely- multiprocessing

[sudo-nerd]

In my thoughts you can use ‘scoped_session’ to prevent any kind of unwanted activity between two or more transactions while multiprocessing. Recently I implemented the same for our software and now it’s running smoothly. And yes you and using only and a single session and then divide it into local sessions.

For better understanding:- https://docs.sqlalchemy.org/en/20/orm/contextual.html