Simon Willison’s Weblog

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

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.

This is Is there a maximum number of records one can fetch with a MySQL query? by Simon Willison, posted on 23rd September 2013.

Tagged ,

Next: What is a good, simple SaaS tool for testing SOAP calls?

Previous: Are you less likely to be accepted to Y Combinator if you don't know how to make money yet?