On Wed, Dec 10, 2008 at 11:28 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Wed, Dec 10, 2008 at 11:08 AM, Said Ramirez <sramirez@vonage.com> wrote:
>> Is there a limit to the number of entries I can pass in an IN clause as part
>> of a SELECT statement? As in
>> SELECT baz FROM foo where id in ( 1, 2,... ) ;
>
> I think it's high enough you'd have performance problems before it
> would fail. If there even is one.
Just tested it with a subselect with 10M rows in an in clause. Not
sure if that's the same as literal strings though.