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

Matija Grabnar matija at serverflow.com
Mon Oct 24 08:48:30 GMT 2011

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.

More information about the DBIx-Class mailing list