ioannes wrote:
"If you use LIMIT row_count with ORDER BY, MySQL ends the sorting as
soon as it has found the first row_count lines rather than sorting the
whole table. "
http://dev.mysql.com/doc/mysql/en/limit-optimization.html
I need to get the top $num results from a completely sorted table (e
"If you use LIMIT row_count with ORDER BY, MySQL ends the sorting as soon as
it has found the first row_count lines rather than sorting the whole table.
"
http://dev.mysql.com/doc/mysql/en/limit-optimization.html
I need to get the top $num results from a completely sorted table (eg sorted
on ID