Re: max length of sql select statement ?

> > but how are you searching through your table with sql, when your SELECT
> > is against a collection of different elements (e.g. Array of Strings,
> > which should fit on one column and return all records which fit)
> 
> Are the 'a', 'b', etc... fixed or generated on the fly?  I'm not sure
> that the plan for a thousand OR clauses (or equivalently a thousand
> entries in a static IN) is going to necessarily be terribly good.  You
> might have better luck setting it up to do a join with a table (possibly a
> temporary table if they're generated on the fly).

Generated "on the fly" by JDBC within Java ;-)
I already tried the join, but it takes ages *g*