[Dbix-class] Regarding Oracle's 1000 element limit in IN clause

[Matija Grabnar]

You have another possibility: create the temporary tables in another 
database. This database can be on your OWN server, so the HUGE company 
doesn't even have to know about it.

If you were to download the full resultset and do the searching in Perl 
you would in effect be doing the
same thing, except your database would be in your RAM, and you would be 
using Perl instead of SQL
to search for it. For large datasets (which this seems to be) a database 
on the local server is more efficient than doing it all in RAM.