Re: [sqlalchemy] Using SQL_CALC_FOUND_ROWS

[Mike Bayer]

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 at a time (and if you are using ORM sessions, using 
each Session in just one application thread at a time).   Also of course 
on that one Session / Connection you need to make sure to query 
FOUND_ROWS() immediately after your query.


if you need this to be local to a cursor, you'd need to drop into direct 
connection / cursor access see 
http://docs.sqlalchemy.org/en/latest/core/connections.html#working-with-raw-dbapi-connections 
but I have a feeling this is not necessary.



On 05/23/2016 04:34 PM, James Li wrote:

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? Is the total count cached somewhere in a
sqlalchemy session after /select SQL_CALC_FOUND_ROWS/ runs? Can I
control where it gets cached in my code?

Thanks!
-james

--
You received this message because you are subscribed to the Google
Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to sqlalchemy+unsubscr...@googlegroups.com
.
To post to this group, send email to sqlalchemy@googlegroups.com
.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.


--
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

[sqlalchemy] Using SQL_CALC_FOUND_ROWS

[James Li]

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? Is the total 
count cached somewhere in a sqlalchemy session after *select 
SQL_CALC_FOUND_ROWS* runs? Can I control where it gets cached in my code?

Thanks!
-james

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.