3 ms·
fun fact: mysql did not do this up to v5.6, afaict. This means a query like select * from ... order by non-index-column-or-calculated limit k it would du
by riffraff 15y ago
fun fact: mysql did not do this up to v5.6, afaict.
This means a query like
select * from ... order by non-index-column-or-calculated limit k
it would dump all the results into a temp table (possibly on disk) and then sort them, instead of keeping a current top-k buffer.