Simon Willison’s Weblog

Is there a maximum number of records one can fetch with a MySQL query?

23rd September 2013

My answer to Is there a maximum number of records one can fetch with a MySQL query? on Quora

To my knowledge there is no upper limit—that’s why good database libraries provide abstractions that let you iterate over large queries without loading the entire result set in to memory at once.