Lo'oris wrote:
> If I have a query that WILL affect only one row (or none), because it
> has a condition such as " WHERE primary_key='$x' ", adding "LIMIT 1"
> will improve performance, or mysql is smart enough anyway?
>
> I ask this because I noticed phpmyadmin often does that in situations
> like this, so this doubt hit me.
>
> Thanks (hope I explained clearly enough).
>
Here is the official version with some user comments:
http://dev.mysql.com/doc/refman/5.0/...imization.html

--

//Aho