On Tue, Sep 13, 2011 at 21:34, Alex Nikitin <niks...@gmail.com> wrote:
> And this will be faster or at least more efficient with a limit (e.g. limit
> 50) this way when you have found the 50 users in the "in" statement, you
> don't continue iterating through the rest of your data set...

The number is never exactly 50 but rather some arbitrary large number.
But there is no need for LIMIT, that is the purpose of the _INNER_
JOIN. INNER means to only return the matching rows.

Dotan Cohen


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to