Does adding 'LIMIT 1' to MySQL queries make them faster when you know there will only be 1 result?
Asked 2009-01-18T17:08:37.843
110
When I add LIMIT 1 to a MySQL query, does it stop the search after it finds 1 result (thus making it faster) or does it still fetch all of the results and truncate at the end?