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.
More recent articles
- LLM 0.22, the annotated release notes - 17th February 2025
- Run LLMs on macOS using llm-mlx and Apple's MLX framework - 15th February 2025
- URL-addressable Pyodide Python environments - 13th February 2025