top | item 45631971

(no title)

fipar | 4 months ago

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.

discuss

order

dotancohen|4 months ago

Even without an ORDER BY clause?

fipar|4 months ago

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