When combining LIMIT row_count with DISTINCT, MySQL stops as soon as it finds row_count unique rows.


http://dev.mysql.com/doc/mysql/en/DI...imization.html