Why One Thread Can't Not Detect The Changed Value Updated By The Other Thread?

I am writing a program using SQLAlchemy, python, and multithreading. In my design, Thread A uses a while True loop. In each loop, it gets the queried object from database by SQLAlc

Solution 1:

This cause by the isolated nature of transactions

A transaction with an average degree of isolation will hold onto the state that it has loaded thus far, and keep giving you that same state local to the transaction even though the real data has changed - this is called repeatable reads in transaction isolation parlance.

How to disable SQLAlchemy caching?