In mysql, the db will continue reading even if the limit condition has been met,... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		fipar 3 months ago \| parent \| context \| favorite \| on: SQL Anti-Patterns 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.

dotancohen 3 months ago [–]

Even without an ORDER BY clause?

fipar 3 months ago | [–]

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

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact