Subject RE: [firebird-support] The known limit (1499) in IN clause
Author Sasha Matijasic
> Firebird does not support more than 1499 elements in an IN clause
> list. Is there any effort to raise this limit? I understand that we
> must try to avoid cases where the number of elements in an IN list is
> big, but there are circumstances such as DSQL (e.g. using DSQL in a
> c++ code) where we are faced with this limit. For example, an
> application receives 2000 identifiers and it must perform a query to
> get records identified by these identifiers.
> So, what is the recommended workaround for this limit (e.g. in terms
> of performance)?

There was a thread last week with a subject "IN clause limitation" on the same topic. You might want to read that.