Hacker News Reader

In mysql, the db will continue reading even if the limit condition has been met, and then anything beyond the limit will be discarded before returning the result.

View on HN

Even without an ORDER BY clause?

Nope, that does work as expected, unless a filesort is required, good point.

Reply on news.ycombinator.com