Performance / limitations of WHERE ... IN queries

[Thierry Templier]

Hello,

I wonder what are the performances of WHERE ... IN queries especially 
when the number of elements in the IN grows?

Thanks very much for your help!
Thierry