I answered this for someone some time ago, assuming FOUND_ROWS() is
local to a MySQL session (note this is not the same thing as a
SQLAlchemy session though typically these map in a 1-1 fashion) there
should be no issue, as long as you are using each connection in just one
application thread
Hi All,
I want to use SQL_CALC_FOUND_ROWS with my select query and use a following
SELECT FOUND_ROWS() to get the total count in sqlalchemy. But how do I make
sure *SELECT FOUND_ROWS()* returns the correct cached value in the case of
*concurrent* queries of *select SQL_CALC_FOUND_ROWS* happen?