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 73 days 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 72 days ago [–]

Even without an ORDER BY clause?

fipar 71 days ago | [–]

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

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