Flimm,
I've not heard of anyone hitting a race condition with SQL_CALC_FOUND_ROWS/FOUND_ROWS() and I can't think how one might arise given that a DBI script maintains a single handle to the DB and that selectall_arrayref ought to happen atomically. Doing some testing may p[ut your mind at rest if you are concerned...
Flimm, I've not heard of anyone hitting a race condition with SQL_CALC_FOUND_ROWS/FOUND_ROWS() and I can't think how one might arise given that a DBI script maintains a single handle to the DB and that selectall_arrayref ought to happen atomically. Doing some testing may p[ut your mind at rest if you are concerned...